converting time zones for negative times
How do I get EXCEL to display a negative time using this formula (or another if it will work)? I am trying to create a time chart where my destination city is 14 hours behind my originating city. Depending upon the time of day, the destination city is sometimes still in the previous day but EXCEL won't show the time, it only shows #####################.
Last edited by VBA Noob; 10-31-2007 at 05:14 AM.
Just add 1 to the result to get a positive timevalue, then the time will show correct. Now problem to do this on the positve times too. They will still show correct on the screen. Could be more trouble if you use the numbers for calculation.
Adding 1 to a time/date value is the same as adding 1 day or 24 hours.
Adding 1 can be problematic, especially if you want to do further calculations with the result. Try using MOD, e.g.
=MOD(C12-14/24,1)
You can use this method to always return just a time (in excel terms a value between 0 and 1) even if C12 contains a date and time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks