| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting time
Hello,
Using the following formula I am receiving data that is not correct: =IF(B6-E6<0,"-"&TEXT(ABS(B6-E7)/24,"[h]:mm"),B6-E6) I would like to have a formula that will subtract time. For example I need the return data in D1 to be -0:00:45. In D2 it needs to be +0:12:09 etc€¦ Thanks in advance for your help. Assoc 12:29:15 PM 12:30:00 PM -0:11 Assoc 8:12:09 AM 8:00:00 AM 0:12:09 Assoc 7:53:28 AM 8:00:00 AM -0:02 Assoc 6:56:45 AM 7:00:00 AM -0:05 Assoc 8:57:20 AM 9:00:00 AM -0:02 Assoc 7:58:18 AM 8:00:00 AM -0:03 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a time a measurement of time, not an hour of the day?? | Excel Discussion (Misc queries) | |||
| time sheet | Excel Discussion (Misc queries) | |||
| Subtracting time | Excel Worksheet Functions | |||
| unmet challenge | Excel Worksheet Functions | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Threaded Mode
