Time to Value

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

3:05 a.m. to 305, 3:05 p.m. to 305
5:15 a.m. to 515, 5:15 p.m. to 515

Could I please have a formula to convert the above

Thanks
 
Try:

=HOUR(IF(A1>0.5,A1-0.5,IF(A1<1/24,A1+0.5,A1)))&TEXT(MINUTE
(A1),"00")

HTH
Jason
Atlanta, GA
 
Hello again Jason from Steved

I copied your formula into B1 it is giving me #VALUE!
In A1 I type 3:05 a.m.

Can you please give me an idea as to what I may be doing
wrong

Cheers
 
That is because Excel doesn't consider 3:05 a.m. to be a valid time value.
Try 3:05 am.

Sue
 
Back
Top