Total Time
4:11:00
This time is a sum of several other times. I'm trying to subtract 90 minutes from this time, but its not working. The format has a date in it that wont allow it. Is there a certain way I need to do this?
The actual cell is E4. The formula is: "=SUM(D2:D103)"
D2-D103 are in this format
1/0/1900 0:00
1/0/1900 0:11
1/0/1900 0:00
thanks
4:11:00
This time is a sum of several other times. I'm trying to subtract 90 minutes from this time, but its not working. The format has a date in it that wont allow it. Is there a certain way I need to do this?
The actual cell is E4. The formula is: "=SUM(D2:D103)"
D2-D103 are in this format
1/0/1900 0:00
1/0/1900 0:11
1/0/1900 0:00
thanks