| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time
Hi everyone,
I need to figure out how to calculate time, as in 9:00pm - 1:30am = 4.5hours. The issue im running into is crossing the midnight threshold. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating time
=mod(b1-a1,1)*24
Format as general, or a number Regards, Fred. "Lost" wrote in message ... Hi everyone, I need to figure out how to calculate time, as in 9:00pm - 1:30am = 4.5hours. The issue im running into is crossing the midnight threshold. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating time
Thanks it worked kinda.... i needed to change it a bit to
=24-(mod(b1-a1,1)*24) otherwise it gave me the result of 20.0 But thank you very much!!!! your a peach "Fred Smith" wrote: =mod(b1-a1,1)*24 Format as general, or a number Regards, Fred. "Lost" wrote in message ... Hi everyone, I need to figure out how to calculate time, as in 9:00pm - 1:30am = 4.5hours. The issue im running into is crossing the midnight threshold. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating time
That would be because you are calculating StartTime - EndTime. I had assumed
you would do it the standard way: EndTime - StartTime. Regards, Fred. "Lost" wrote in message ... Thanks it worked kinda.... i needed to change it a bit to =24-(mod(b1-a1,1)*24) otherwise it gave me the result of 20.0 But thank you very much!!!! your a peach "Fred Smith" wrote: =mod(b1-a1,1)*24 Format as general, or a number Regards, Fred. "Lost" wrote in message ... Hi everyone, I need to figure out how to calculate time, as in 9:00pm - 1:30am = 4.5hours. The issue im running into is crossing the midnight threshold. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
| Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Calculating effective time from start/end date+time | Excel Worksheet Functions | |||
Linear Mode
