View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
 
Posts: 70
Default 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