View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kurt S Kurt S is offline
external usenet poster
 
Posts: 6
Default Calculating time in minutes

I have a spreadsheet that I enter the start and end times of a project. I
would like to be able to calculate the time spent in minutes. IE. I enter the
time I started in cell C1 and the end time in cell C2. If I enter the formula
"=C2-C1" it will calculate the time, but it does it in hours and minutes.
What formula can I use to calculate the time in minutes only?