Excel date formula

[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!

 

[Frank Kabel]

Hi
try
=A1-7/24+(A1<7/24)
and format this as time

 

[Peo Sjoblom]

Another way

=MOD(A1-7/24,1)

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

Regards,

Peo Sjoblom