R
ricky
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
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