GMT to Central Tme

[Nunzio]

I need to subtract 5 hours from military times in SAP. I am having problems when subtracting from military times less then the 5 hours.

[shg]

What result would you expect? The "borrow" has to come from the date.

If A1 contains a date and time, then =A1-"5:00" returns the time five hours earlier, which may be on the prior date.

If A1 just contains a time, then =A1-"5:00" + (A1-5":00"<0) returns just the time.

[daddylonglegs]

if just times you could also try this

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

[shg]

See my post at MrE ...

[Nunzio]

Thanks daddylonglegs