Hello need help calculating a quick time zone correction in excel
A1 Time in GMT
A2 ( i want to calculate time in PST, 8 hours behind time from A1)
Thanks.
Hello need help calculating a quick time zone correction in excel
A1 Time in GMT
A2 ( i want to calculate time in PST, 8 hours behind time from A1)
Thanks.
Last edited by fabes253; 07-04-2012 at 05:24 PM.
If A1 contains a time only then try this formula in A2
=MOD(A1-8/24,1)
format A2 as time
Audere est facere
perfect thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks