cblincoln43
Board Regular
- Joined
- Mar 12, 2002
- Messages
- 206
The numbers i use are in tenth of an hour, the time is for starting time (-) ending time (=) hours. or,
...f7.........e7...(=)...g7.
..5:30pm....2:00am.(=).8.5hrs.
I need:
...5.5pm... 2.0am .(=).8.5 hrs.
I have tryed formating cells to costom 0.00"hours"
in g7,,,=if(f7-e7<0,f7-e7+1,f7-e7)*24. and it returns #VALUE, in g7. I can't seem to get this problem past the midnight hour without creating a 36 hour day.
What am i doing wrong or can i get this thing to give me tenths for time?
This message was edited by cblincoln43 on 2002-04-07 05:32
...f7.........e7...(=)...g7.
..5:30pm....2:00am.(=).8.5hrs.
I need:
...5.5pm... 2.0am .(=).8.5 hrs.
I have tryed formating cells to costom 0.00"hours"
in g7,,,=if(f7-e7<0,f7-e7+1,f7-e7)*24. and it returns #VALUE, in g7. I can't seem to get this problem past the midnight hour without creating a 36 hour day.
What am i doing wrong or can i get this thing to give me tenths for time?
This message was edited by cblincoln43 on 2002-04-07 05:32