Calculating time in Excel

[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?

 

[Matthew]

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

 

[Niek Otten]

Format>Cells>Custom, enter [m] in the type box

 

[Niek Otten]

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

Format>Cells>Custom, enter [m] in the type box

--
Regards,

Niek Otten
Microsoft MVP - Excel

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?