View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default hours and minutes

If A1 contains Seconds, then
=a1/60 (in B1) would contain minutes
=b1/60 (in C1) would contain hours
=c1/24 (in D1) would contain days

Pam Coleman wrote:

If I have a spreadsheet that in column A= seconds. I want to take the
seconds in col a and in column b make minutes, then in column c, the minutes
to make hours, and then in column d, the hours to make days. I do not know
how to divide to get the correct answer in each of the columns.


--

Dave Peterson