Subtracting Times producing negative numbers

doug.sloane

New Member
Joined
Jun 18, 2002
Messages
13
I have 2 columns with times in them in a HH:MM format.I'm trying to subtract them from each other but when the column I'm subtracting is greater than the column being subtracted form I get garbage as the result. I can understand why negative time is a problem in a quantum physics sense (or maybe not) but why is it a problem to show a negative HH:MM ???? I could do it with a big long macro / formula with mod 60 for minutes and mod 24 for hours but don't want to. Is there an easier way ?
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,379
Members
412,589
Latest member
ArtBOM
Top