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

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

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

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

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