View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Adding minutes to Times

Try this:

=A1+B1/60/24

where A1 contains the time (eg 06:15:00) and B1 contains the minutes as
whole numbers. Format the cell containing the formula as time.

Hope this helps.

Pete

ricky wrote:
Hi

I have a spreadsheet which contains Times, and I wish to add minutes, anyone
know the formula required?

E.g

Time is 0615 and I wish to add 248 minutes, although this could be any value
of minutes.

I've tried something like : (Where A1 = 06:15:00 )
= A1 + 245, but that doesn't work obviously, so I tried to isolate the
Minute portion using MINUTE(A1) + 245, but this doesn't take in to account
of the hours.

Does anybody have a simple formula which can perform this?

Kind Regards

Ricky