There is a simple correction but I have a question. Does 651 represent 6:51
AM or 6:51 PM or both?
Excel maintains time as a decimal fraction. 6:51 AM is 0.285417 and 6:51 PM
is 0.785417

Tyro


"Meebers" wrote in message
...
Had some workers inserting times as 651 and 710. Obviously they have to be
changed to 6:51 and 7:10. I hate to think I have to manually edit them
all to correct. Multiple rows and pages to fix :0( Any suggestions?