Calculating time in Excel

  • Thread starter Thread starter Mandy Quartz
  • Start date Start date
M

Mandy Quartz

I am trying to figure out the formula to calculate time,
for example: I have 2:00 in the first cell and 4:00 in
the next cell, I want to figure out that the difference
is 120 minutes. Is this possible?
 
I don't see a direct way, but you can format the cell with the formula as
normal and multiply by 24 to get the result in hours, or by 1440 to get the
result in minutes. There just happen to be 1440 minutes in a day :-)

Matthew
 
Unless you want to calculate with the result as 120; then indeed you'll have
to multiply by 1440 and format as a number

--
Regards,

Niek Otten
Microsoft MVP - Excel

Niek Otten said:
Format>Cells>Custom, enter [m] in the type box

--
Regards,

Niek Otten
Microsoft MVP - Excel

Mandy Quartz said:
I am trying to figure out the formula to calculate time,
for example: I have 2:00 in the first cell and 4:00 in
the next cell, I want to figure out that the difference
is 120 minutes. Is this possible?
Click to expand...
Click to expand...
 
Back
Top