M
Metalteck
If i have a time formatted as 2:55 hrs, how can I convert this to just a
total of minutes, for example 2:55 = 135 minutes?
total of minutes, for example 2:55 = 135 minutes?
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.
N
Niek Otten
I assume you mean 175 minutes.
Format>Cells>Custom, in the Type box, enter [m]
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
Format>Cells>Custom, in the Type box, enter [m]
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
H
Harald Staff
Multiply it by 1440 and format the result as a decimal number.
(Because there are 1440 minutes in a day. You knew that ;-)
HTH. Best wishes Harald
(Because there are 1440 minutes in a day. You knew that ;-)
HTH. Best wishes Harald
J
JoAnn Paules - MVP Publisher
I do NOT want a job wherever he works. Work 2 hrs and 55 minutes, get paid
for 2 hrs and 15 minutes? Not me.
JoAnn Paules
MVP Publisher
for 2 hrs and 15 minutes? Not me.
JoAnn Paules
MVP Publisher
Niek Otten said:I assume you mean 175 minutes.
Format>Cells>Custom, in the Type box, enter [m]
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
Metalteck said:If i have a time formatted as 2:55 hrs, how can I convert this to just a
total of minutes, for example 2:55 = 135 minutes?