Convert Seconds into time of day

T

The Rook

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
 
T

T. Valko

Use another cell to convert:

B1 = 52132

=B1/86400

Format in the time style of your choice.
 
Top