Excel date formula

T

Tom

I have one cell with a time in it 05:00:00 and I want to
subtrct 7 hours from it - (to adjust for Greenwich Mean
time)but if the time is less then 07:00:00 I get an
error - any help would be appreciated - thanks!
 
P

Peo Sjoblom

Another way

=MOD(A1-7/24,1)

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top