Adding 73 minutes to Time

[The Animal]

Hi.
I have an array of times in (1:30:55 pm format) that I need to add 73 minutes onto each time.
Any help appreciated.
Thanks Stephen

 

[Scott Huish]

By array of times, do you mean an array in VBA. Or a range of cells on the spreadsheet with times?

 

[jeffreybrown]

If a range in the spreadsheet then maybe...

=A1+73/1440

 

[Scott Huish]

If it is a range of cells, in a blank cell, put the following formula:

=73/1440

Copy this cell.

Select your range of cells to add the time to:
Right Click and Click on Paste Special
Under Operation, click Add.
Click OK.

 

[The Animal]

Thanks Guys