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?

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?

In this particular example, it represents 6:51 am . there are entries such
as 1851 also that have to be converted to 18:51


"Tyro" wrote in message
.. .
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?