Home |
Search |
Today's Posts |
#1
|
|||
|
|||
time ???
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? |
#2
|
|||
|
|||
I assume you mean 175 minutes.
FormatCellsCustom, in the Type box, enter [m] -- Kind Regards, Niek Otten Microsoft MVP - Excel "Metalteck" wrote in message ... 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? |
#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 "Metalteck" skrev i melding ... 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? |
#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" wrote: I assume you mean 175 minutes. FormatCellsCustom, in the Type box, enter [m] -- Kind Regards, Niek Otten Microsoft MVP - Excel "Metalteck" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |