Convert to Hour
Multiply 40:30 by 24 and format the cell as a number.
(Excel stores time as fractions of a 24 hour day; multiplying by 24 cancels
the 24 and formatting as a number, as opposed to time, converts 40:30 to the
decimal form 40.5.)
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"Jimmy" wrote:
This is what I have done so far:
C4 is begin Time: 2/7/07 4:00PM
D4 is endin Time: 2/8/07 1:30AM
E4 is Time Differ: =(hour(d4-c4)*60+(d4-c4))."It shows the different tim.
I35 is Total Time: Then I use Sum to count all the time. It shows 40:30
Which is 40 hours and 30 minutes.
How I can convert it to 40.5 hour or other way I can use it to do some other
calculation.
Please help!
Thanks!
|