Hi I am trying to find out what formular to use for calcutating the midway point between 2 separate times.
eg.
A1 = 12:10
B1 = 12:20
I know the answer is 12:15 but how do I get Excel to do it for me?
Hi I am trying to find out what formular to use for calcutating the midway point between 2 separate times.
eg.
A1 = 12:10
B1 = 12:20
I know the answer is 12:15 but how do I get Excel to do it for me?
Last edited by LAB_RAT; 11-02-2011 at 06:03 PM.
Hi,
Formula =(A1*24+B1*24)/2/24 then Format Cells back to Time.
Cheers
TonyB
Thanks Tony,
Worked a charm.
I have another question:
How do I calculate the number of days hours minutes and seconds between 2 date & time ranges.
EG.
A1 = 12/10/11 B1 = 13:56:30
A2 = 19/11/11 B2 = 9:45:00
I want it to display the aswer in number format (eg 12.66 days)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks