G Guest Apr 21, 2005 #1 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?
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?
N Niek Otten Apr 21, 2005 #2 I assume you mean 175 minutes. Format>Cells>Custom, in the Type box, enter [m] -- Kind Regards, Niek Otten Microsoft MVP - Excel
I assume you mean 175 minutes. Format>Cells>Custom, in the Type box, enter [m] -- Kind Regards, Niek Otten Microsoft MVP - Excel
H Harald Staff Apr 21, 2005 #3 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
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
G Guest Apr 22, 2005 #4 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 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? Click to expand... Click to expand...
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 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? Click to expand... Click to expand...
