| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
Always use this white space message area to post your query
Never use the subject line as the query, its not meant for that |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
Hi Richard
It is unclear what you want. You should post the question more explicitly in the body of the message. Just guessing, the times may span a 24 hour period. If so, and with start time in A1 and End time in B1, try =MOD(B1-A1,1) -- Regards Roger Govier "richard.littlewing" <richard.littlewing@gmail wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using if statement to subtract 24 hours from time | Excel Worksheet Functions | |||
| How do I subtract 8 business hours from a date/time value? | Excel Discussion (Misc queries) | |||
| Subtract hours from a time and get the correct time | Excel Worksheet Functions | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
| Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
Linear Mode
