View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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