Date/Time Calculations

[Steve]

I'm trying to calculate a total time to perform a task. I
enter start date and time in column (A) using the 9/2/03
23:30 format. Then in column (B) the same format for end
time 9/4/03 1:30. In column (C) (formatted for time 13:30)
I enter =b1-a1 to get total time. It will give an answer
of 1:00 it's not counting the hours in a full day. Is
there a way to calculate this correctly?

 

[Paul B]

Steve, format the cell in C as custom [h]:mm:ss

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Steve]

Thanks, everything seems to work fine now.

-----Original Message-----
Steve, format the cell in C as custom [h]:mm:ss

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

I'm trying to calculate a total time to perform a task. I
enter start date and time in column (A) using the 9/2/03
23:30 format. Then in column (B) the same format for end
time 9/4/03 1:30. In column (C) (formatted for time 13:30)
I enter =b1-a1 to get total time. It will give an answer
of 1:00 it's not counting the hours in a full day. Is
there a way to calculate this correctly?

.