Trying to figure out the hours between two times. Say, for instance, I have 7:00 PM in cell A1 and 6:00 AM in cell A2. What is my formula in cell A3 to give me the result of 11 hours, the hour time span between A1 and A2?
Thank You
Trying to figure out the hours between two times. Say, for instance, I have 7:00 PM in cell A1 and 6:00 AM in cell A2. What is my formula in cell A3 to give me the result of 11 hours, the hour time span between A1 and A2?
Thank You
Last edited by Juncus; 11-21-2008 at 04:16 PM.
Maybe
or=MOD(B1-A1,1)
VBA Noob=B1-A1+(A1>B1)
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks