time Display

  • Thread starter Thread starter Hakan Dagtas
  • Start date Start date
H

Hakan Dagtas

I managed to display 2hrs (02:00) as 120 [mm] however on a
different cell I have some formulas, which does not read
it as 120. Is there any possiblity to key in the figure as
02:00 display and compute as 120 by using only one cell.
Thanks Hakan
 
If A1 houses 2:00 and a formula needs to read as 120 minutes, use

A1*1440

as term in the formula instead of just A1.
 
Back
Top