I'm trying to convert Excel times that are in GMT time to Local. This is the formula I am using: =E1 - (8 / 24)
I am in the PST so I am subtracting 8 hours from GMT. The issue that I am running into is if the time is earlier than 8:00AM such as 7:59AM and before then it gives me a string of ###### in the cell.
How can I get it so that if the time says 7:00AM it subtracts 8 hours and will give me 11:00 PM and so forth?
David
Last edited by russianspd; 02-09-2012 at 07:57 PM.
=IF(E1<8/24,1+E1,E1)-8/24
should do it
Good luck.
Thanks the times convert perfectly.
Hi
Try something like
For a good reference on this goto this
=IF(TIME(8,0,0) > A1,A1+1-TIME(8,0,0),A1-TIME(8,0,0))
rylo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks