Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two columns in my excel spreadsheet. One is start time (A), the other
is duration time (B). Start Time Duration 08:00 15 08:16 130 10:27 45 Start Time. I have formatted it to Number, Custom, [h]:mm and the formula I have in this column is =sum(F:15:G15)+TIME(0,1,0). This adds the time in column B to the time in column A, plus one minute. Automatically populates. OK. Duration. I have this column formatted to Number, Custom [mm], as I need the duration time in minutes only. However, I can not enter 130 minutes as 130, I have to key it as 2:10 (and it converts it to 130). I want to actually key it as 130 though. Not sure what to do next?? -- Kathy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
Adding hours and minutes | Excel Discussion (Misc queries) | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions |