G
Guest
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
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