Calculation of time differences
Hi,
do you want to get the minutes in C1 enter
=(A1-B1)*1440
1440 is the total minutes in a day
format C1 as a number
"Scott" wrote:
I have a column of times and would like to calculate the time differences
between two times. I tried to use = B3-B2 to find out the time difference
without success. Can someone advise the correct formula used in Excel 2007.
Thanks,
Scott
|