Solved Need formula to calculate time difference between 2 columns

September 24, 2012 at 12:21:31
Specs: Windows 7
I have a column with the hrs:min for start and another column with the hrs:min of end of an activity. it happens within same day.
Hrs are 0-24 and min are 0-59

See More: Need formula to calculate time difference between 2 columns

Report •

#1
September 24, 2012 at 16:55:46
✔ Best Answer
If your data looks like this:

      A       B         C
1)  Start    End       Diff
2)  8:30    13:15    

Simply use a formula that does a subtraction.
In C2 enter the formula =B2-A2

You should get: 4:45

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question