Convert Seconds into time of day
 

I use a database that shows me the time that emplyees clock activities. In
column A it shows the date (which is fine) and in column B it shows the time,
the proble I have is that this is in seconds (number of seconds that have
elapsed from midnight)
For example 52132 with relates to 14:28. How can I get me speadsheet to
show the time ie 14:28?

Thanks

Convert Seconds into time of day
 

Use another cell to convert:

B1 = 52132

=B1/86400

Format in the time style of your choice.

--
Biff
Microsoft Excel MVP


"The Rook" wrote in message
...
I use a database that shows me the time that emplyees clock activities. In
column A it shows the date (which is fine) and in column B it shows the
time,
the proble I have is that this is in seconds (number of seconds that have
elapsed from midnight)
For example 52132 with relates to 14:28. How can I get me speadsheet to
show the time ie 14:28?

Thanks