View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Calculating time in minutes

Hi,

Multiiply by 1440 the number of minutes in a day formatted as general

=(C2-C1)*1440

Mike

"Kurt S" wrote:

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?