Change seconds in hours, minutes and seconds

[Guest]

Our telephone system records the total number of seconds used by a staff member. At the end of the day, I read the dial, convert the seconds into hours, minutes and seconds, record the answer into a spreadsheet. And then do the same for all 26 staff members.
Is there any way that I can type the meter reading into a spreadsheet and then have the number of seconds automatically converted into HH:MM:SS?

 

[Chip Pearson]

You need to divide the number of seconds by the number of seconds
in a day, and format the cell for time. E.g.,

=A1/(60*60*24)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message

Our telephone system records the total number of seconds used

by a staff member. At the end of the day, I read the dial,
convert the seconds into hours, minutes and seconds, record the
answer into a spreadsheet. And then do the same for all 26 staff
members.

Is there any way that I can type the meter reading into a

spreadsheet and then have the number of seconds automatically
converted into HH:MM:SS?

 

[Frank Kabel]

Hi
if A1 stores your seconds try
=A1/(24*60*60)