Thread: Convert to Hour
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jimmy jimmy is offline
external usenet poster
 
Posts: 59
Default Convert to Hour

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!