Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel functions
How can I add up a column of times to give me a total expressed in hrs/mins
and secs or alternatively simply convert a number into minutes and secs - ie 2.82 = 3m22sec ?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel functions
Use SUM() function and format the total cell to CustomFormat [h]:mm:ss
If this post helps click Yes --------------- Jacob Skaria "markwsquires" wrote: How can I add up a column of times to give me a total expressed in hrs/mins and secs or alternatively simply convert a number into minutes and secs - ie 2.82 = 3m22sec ?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel functions
convert a number into minutes and secs - ie 2.82 = 3m22sec ??
What is the range of numbers you have? A1 = 2.82 =TIME(0,INT(A1),MOD(A1,1)*100) Format as m:ss returns 3:22 That won't work on anything greater than or equal to 60 minutes. For example, 60.0 or 59.65. -- Biff Microsoft Excel MVP "markwsquires" wrote in message ... How can I add up a column of times to give me a total expressed in hrs/mins and secs or alternatively simply convert a number into minutes and secs - ie 2.82 = 3m22sec ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple functions, conditional functions | Excel Worksheet Functions | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |