View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kathy Kathy is offline
external usenet poster
 
Posts: 144
Default 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