Subtract time when crossing 24 hours

[PCRIDE]

Hi, I couldn't find the exact solution but I am sure its basic.

I am subtracting 6 hours from standard date and time format in excel using
=A1-6/24

Works fine except when subtracting time less than 6AM I get ############################
The issue here is excel is not able to subtract time less than the hour I am subtracting
In other words its not calculating the previous day time in PM from hours 00:00 through 06:00

Please help!

 

[MarcelBeug]

Possibly you're looking for:

=MOD(A1-6/24,1)

 

[PCRIDE]

I think the issue fixed itself. Thank you I still used the formula!!