Convert Seconds into time of day

  • Thread starter Thread starter The Rook
  • Start date Start date
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
 
Use another cell to convert:

B1 = 52132

=B1/86400

Format in the time style of your choice.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i want to convert decimals into time format 3
can Excel really deal with elapsed time? 1
Time - By 8am the next morning 11
Number Formatting 1
Format for elapsed time 2
Counting text which meets a criteria 2
Calculating every work day between two dates 3
Difference in Days, Hours, Minutes and Seconds 15

Back
Top