To see the difference, in hours (in decimal format), in Col D simply enter
this formula in D1 and copy down
=(C1-B1)*24

Then you can add up Col D to get total hours.

"Linda RQ" wrote:

Hi Everyone,

Using Excel 2003. I am calculating my hours worked. I enter in the start
date and time in the B column and the end date and time in the C column. I
use the shortcut Ctrl : <space Ctrl+Shft+ : to enter this. I have =
TEXT(C3-B3,"h:mm") This is working fine.

At the bottom of my D column I have this =SUM(D2:D16) but it is returning
00:00:00.

I tried using the format cell/custom and picked the hours and minutes as
well as other formats but I can't get it to show up.

I need the total hours and minutes in cell D17

Thanks,
Linda





.