View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Calculating time in minutes

Use custom format [mm]

--


Regards,


Peo Sjoblom



"Kurt S" wrote in message
...
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?