Subtracting 2 hours from time

C

Chappy

Hiya,

I've got a prob which is probably very easy to fix but is leavin me
scratchin my head.

I've got time set in cells and want to take 2 hours from this value. So I'm
trying to change, say, 1:30 to 23:30 etc.

any ideas?? Thanks.
 
P

Peo Sjoblom

With 01:30 in A1

=MOD(A1-"02:00",1)

replace "02:00" with a cell where you put the time you want to subtract

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top