Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic excel functions
What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in
hrs:minutes:seconds) format? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic excel functions
Assuming the number of seconds is in A1,
=A1/86400 Then, format the cell as custom "hh:mm:ss" "dharmender mehra" wrote: What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in hrs:minutes:seconds) format? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic excel functions
To Excel, dates are just integers (the count of days since 12/31/1899) and
times are decimal fractions of days (noon is 0.5) So.....Divide 29,852 by the number of seconds in a day to arrive at the decimal fraction. =29852/(60*60*24) Then use one of the Time formats on the value. Does that help? *********** Regards, Ron XL2002, WinXP "dharmender mehra" wrote: What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in hrs:minutes:seconds) format? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic excel functions
=A1/86400
Custom Format hh:mm:ss "dharmender mehra" wrote: What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in hrs:minutes:seconds) format? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic excel functions
Time is stored as fractional days, so divide by 24*60*60:
A1: 29852 A2: =A1/86400 format as hh:mm:ss In article , "dharmender wrote: What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in hrs:minutes:seconds) format? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel can't do basic math?! | Excel Discussion (Misc queries) | |||
Very Basic Excel Tutorial | Excel Discussion (Misc queries) | |||
Excel and Visual Basic | Excel Discussion (Misc queries) | |||
visual basic in excel - | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |