Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time after midnight
Hello from Steved
This formula converts a number in to time =TEXT(D25,"0\:00")*1 ie 1530 15:30 My Question please the only way the formula will reconize 1210 am the next day is to type 2410, I would like to type 10, what is require to the formula above to acheive this. an example would be 15:30 to 24:10 as at the moment, I would like to type in 15:30 to 0:10 to give a total hours as 08:40 ( after midnight ) Thankyou. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time after midnight
Time should be 15:30 and 00:10 then use formula =mod(b1-a1,1)
"Steved" wrote in message ... Hello from Steved This formula converts a number in to time =TEXT(D25,"0\:00")*1 ie 1530 15:30 My Question please the only way the formula will reconize 1210 am the next day is to type 2410, I would like to type 10, what is require to the formula above to acheive this. an example would be 15:30 to 24:10 as at the moment, I would like to type in 15:30 to 0:10 to give a total hours as 08:40 ( after midnight ) Thankyou. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time after midnight
Thankyou
"Mike G" wrote: Time should be 15:30 and 00:10 then use formula =mod(b1-a1,1) "Steved" wrote in message ... Hello from Steved This formula converts a number in to time =TEXT(D25,"0\:00")*1 ie 1530 15:30 My Question please the only way the formula will reconize 1210 am the next day is to type 2410, I would like to type 10, what is require to the formula above to acheive this. an example would be 15:30 to 24:10 as at the moment, I would like to type in 15:30 to 0:10 to give a total hours as 08:40 ( after midnight ) Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time around midnight | Excel Worksheet Functions | |||
time clock wrap around midnight | Excel Worksheet Functions | |||
subtraction off time after midnight | Excel Worksheet Functions | |||
Calculating Time Past Midnight | Excel Worksheet Functions | |||
Calculating time difference over midnight! | Excel Discussion (Misc queries) |