| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtraction off time after midnight
Hello from Steved
I have 7:10 p.m. to 12:15 a.m. What formula do I use to subtract 12:15 a.m. from 7:10 p.m. please. I would like it to show 05:05 Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtraction off time after midnight
Hi Steve
With 12:15 AM in A1 and 7:10 PM in A2 =MOD(A1-A2,1) -- Regards Roger Govier "Steved" wrote in message ... Hello from Steved I have 7:10 p.m. to 12:15 a.m. What formula do I use to subtract 12:15 a.m. from 7:10 p.m. please. I would like it to show 05:05 Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtraction off time after midnight
Hello Roger
Excellent and Thankyou. "Roger Govier" wrote: Hi Steve With 12:15 AM in A1 and 7:10 PM in A2 =MOD(A1-A2,1) -- Regards Roger Govier "Steved" wrote in message ... Hello from Steved I have 7:10 p.m. to 12:15 a.m. What formula do I use to subtract 12:15 a.m. from 7:10 p.m. please. I would like it to show 05:05 Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hot key for time? | New Users to Excel | |||
| Hot key for time? | Excel Worksheet Functions | |||
| Hot key for time? | Excel Discussion (Misc queries) | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
Linear Mode
