Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minuts and Seconds to only seconds???
Hallo
I have a question about time formats in exel. If I f.ex have the time 1 minut and 31 seconds (tt:mm:ss) = 0:01:31 but i want the time only in seconds (ss) = 91. How do I do that? I hope you can help me! Greetings Mikkel |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minuts and Seconds to only seconds???
=A1*86400
Format cell as General "Mikkel" wrote: Hallo I have a question about time formats in exel. If I f.ex have the time 1 minut and 31 seconds (tt:mm:ss) = 0:01:31 but i want the time only in seconds (ss) = 91. How do I do that? I hope you can help me! Greetings Mikkel |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minuts and Seconds to only seconds???
to display only seconds use this custom number format
[ss] the brackets allow for the overflow. to calculate the number of seconds use the following formula (similar to one already given by Teethless. =A1*24*60*60 you will need to format the cell as a number (or general). "Mikkel" wrote: Hallo I have a question about time formats in exel. If I f.ex have the time 1 minut and 31 seconds (tt:mm:ss) = 0:01:31 but i want the time only in seconds (ss) = 91. How do I do that? I hope you can help me! Greetings Mikkel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
degrees minutes and seconds | Excel Discussion (Misc queries) |