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

Thanks for the answers guys. Mike, your formula worked great. Peo, I had
tried that already. It just gave me the minutes, and didn't calculate the
hours into minutes.

"Peo Sjoblom" wrote:

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?