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.

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


"Chappy" wrote in message
...
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.

Thanks Peo!