Converting number to time

[cathe]

Hello,

I'm working with some data to show open rates per hour to an email. In the time field, I have a 1 representing the first hour after the email was sent, 2 representing the second hour etc. The email was sent at 6am, so I'd like to be able to convert the numbers to text (i.e. '6am') for tables and chart labels.

I think the formula I'm looking for is one that looks up the column of numbers containing 1, 2 etc, and if it finds a 1, it returns the value 6am, if it finds a 2, it returns the value 7am etc.

Any suggestions would be appreciated. Thank you.

 

[steve the fish]

Hi. How does it know 6am is the start time? Or is it always the start time?

A possible if 6am is always the start:

=TIME(A1+5,0,0)

 

[Special-K99]

Maybe

=TIME(A1+5,0,0)

where A1 is the hour.
Presumably this won't execeed 24 (or more likely 18)

 

[AlanY]

deleted