Negative Time Numbers

  • Thread starter Thread starter JT
  • Start date Start date
Assume times are entered in A1 (first time) and B1 (second time).
C1: =IF(B1>A1,"- ","+ ")&TEXT(ABS(A1-B1),"[hh]:mm")

That being said, since it is now a text cell, in order to manipulate this
time, you would need something like the following.
Assume cell B3 has time that needs to be modified by your time in C1.
C3: =B3+MID(C1,3,LEN(C1)-2)*IF(LEFT(C1,1)="-",-1,1)

It works....
 
Try to check 1904 style dates in Tools>Options>Calculation!

Regards,
Stefi

„JT†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
Negative time values 2
Negative hours [h]:mm:ss 5
Time - Hours and Minutes 4
Displaying negative [h]:mm:ss 2
Time, & Ceiling? 3
To Display Negative Dates 2
Negative Time Format 1

Back
Top