Convert 08:00 to 0800

[JamesBowdidge]

Hi,

I have a "floating point" issue on a spreadsheet I receive and need to convert the time that is a decimal (formatted as "08:00", 08:15", "08:30", etc etc) to 0800 or 800 etc..

Anyone have a formula for this?

thanks

J

 

[Phuoc]

Try:

=TEXT(A1,"hmm")

 

[JamesBowdidge]

Thanks Phuoc..

just fot to that myself.. was over thinking it!! LOL

thanks very much for replying tho!

J