Greetings, I am looking for a formula that will enable me to sum hours and minutes from a date range. I am invariably looking back from TODAY(). Example data

1-Apr-13 1:30
6-Apr-13 0:20
15-Apr-13 7:00
20-Apr-13 0:45
24-Apr-13 8:15

I would like to be able to sum the time using ie. TODAY()-10, for a period looking at column A?

Thanks in advance for your help!

Harry