Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding minutes to hours/minutes
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding minutes to hours/minutes
Format as general and type in 130, then use
=A1+(B1/1440) make sure you format the cell with formula as hh:mm or [hh]:mm with 08:00 in A1 and 130 in B1 that would return 10:10 If you just want to display the duration without any other calculation just format as general and type in 130 -- Regards, Peo Sjoblom "Kathy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding minutes to hours/minutes
Kathy,
With the duration column formatted as [mm] key in 00:130 it will display 130 minutes if you then add this in a cell formatted as [mm] you'll get the result in minutes Mike "Kathy" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding minutes to hours/minutes
start time (A), the other is duration time (B).
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 Then why is your formula referencing column F? Why don't you just format as General (or Number, 0 decimal places) and enter it as an integer 130? Then: =SUM(A15,B15/1440,1/1440) -- Biff Microsoft Excel MVP "Kathy" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding minutes to hours/minutes
something like...........
=SUM(F15:G15)+TIME(0,1,0)+B2/(24*60) the /(24*60) part changes the units you enter from days to minutes -- Greetings from New Zealand "Kathy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |