Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conversion seconds into minutes/hours
I have a telephone-report that gives me the number of seconds each
conversation has taken. I want to convert these seconds in a hh:mm:ss format. Is there a function or a formula available in Excel that can do that? Tnx |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conversion seconds into minutes/hours
Put 86400 in a spare cell and copy it.
Select your range Goto EditPasteSpecial and click Divide OK Format the cells as time, and claer the cell with 86400 in it -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Willem" wrote in message ... I have a telephone-report that gives me the number of seconds each conversation has taken. I want to convert these seconds in a hh:mm:ss format. Is there a function or a formula available in Excel that can do that? Tnx |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conversion seconds into minutes/hours
=A1/24/60/60, Format as [hh]:mm:ss
-- Kind regards, Niek Otten Microsoft MVP - Excel "Willem" wrote in message ... |I have a telephone-report that gives me the number of seconds each | conversation has taken. I want to convert these seconds in a hh:mm:ss format. | Is there a function or a formula available in Excel that can do that? | | Tnx | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conversion seconds into minutes/hours
Seconds in A2, the following formula will convert
=A2/60/60/24 Format as [h]:mm:ss Steve On Wed, 22 Nov 2006 14:21:24 -0000, Willem wrote: I have a telephone-report that gives me the number of seconds each conversation has taken. I want to convert these seconds in a hh:mm:ss format. Is there a function or a formula available in Excel that can do that? Tnx |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conversion seconds into minutes/hours
seeing your solutions makes me small......
thanks a lot! "SteveW" wrote: Seconds in A2, the following formula will convert =A2/60/60/24 Format as [h]:mm:ss Steve On Wed, 22 Nov 2006 14:21:24 -0000, Willem wrote: I have a telephone-report that gives me the number of seconds each conversation has taken. I want to convert these seconds in a hh:mm:ss format. Is there a function or a formula available in Excel that can do that? Tnx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate call cost in seconds | Excel Worksheet Functions | |||
Coverting seconds, to minutes and seconds | Excel Worksheet Functions | |||
How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |