T
time conversion
I want to know how to change a standard time cell to all minutes?
example: 1:15 - 75
example: 1:15 - 75
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How do I change a time such as 1:15 to all minutes such as 75?
B
Bob Phillips
=I1*24*60
P
Peo Sjoblom
Format as [m]
or multiply by 1440 and format as number of general
--
Regards,
Peo Sjoblom
or multiply by 1440 and format as number of general
--
Regards,
Peo Sjoblom
M
Mike H
Apply a custom format of
[mm]
Mike
[mm]
Mike
T
time conversion
so...if 1:15 is in cell F3.......and I use cell G3 to write the
formula.....what do I type in the cell?
formula.....what do I type in the cell?
Peo Sjoblom said:Format as [m]
or multiply by 1440 and format as number of general
--
Regards,
Peo Sjoblom
time conversion said:I want to know how to change a standard time cell to all minutes?
example: 1:15 - 75
M
Mike H
2 ways
in g3 enter the formula
=F3
Then
Format|Cells|
Select Custom
enter a cutom formula of [mm]
Click ok
Or
enter the formula in g3
=F3*1440
This time format the cell as general
Mike
in g3 enter the formula
=F3
Then
Format|Cells|
Select Custom
enter a cutom formula of [mm]
Click ok
Or
enter the formula in g3
=F3*1440
This time format the cell as general
Mike
time conversion said:so...if 1:15 is in cell F3.......and I use cell G3 to write the
formula.....what do I type in the cell?
Peo Sjoblom said:Format as [m]
or multiply by 1440 and format as number of general
--
Regards,
Peo Sjoblom
time conversion said:I want to know how to change a standard time cell to all minutes?
example: 1:15 - 75