Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
If this function works: =TEXT(F9-E9, "hh:mm:ss"), why doesn't this:
=TEXT(H2:H9, "hh:mm:ss")? I have a form enter start and end times. In another column I use the first function above to calculate the elapsed time. I would like to total that column in hh:mm:ss format. How do I do this? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
Because you have a "-" in the first place and a ":" in the second?
"Tamara" wrote in message ... If this function works: =TEXT(F9-E9, "hh:mm:ss"), why doesn't this: =TEXT(H2:H9, "hh:mm:ss")? I have a form enter start and end times. In another column I use the first function above to calculate the elapsed time. I would like to total that column in hh:mm:ss format. How do I do this? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
Hi Tamara,
=TEXT( XXX , "hh:mm:ss") is only a way to show differently XXX. In first case, XXX is a difference. In second, H2:H9 is a group of cells. But what Excel needs to do with this group to give a result ? You indicated to search for a total : Does =TEXT(sum(H2:H9), "hh:mm:ss") answer your wish ? @+ FxM Tamara a écrit : If this function works: =TEXT(F9-E9, "hh:mm:ss"), why doesn't this: =TEXT(H2:H9, "hh:mm:ss")? I have a form enter start and end times. In another column I use the first function above to calculate the elapsed time. I would like to total that column in hh:mm:ss format. How do I do this? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
you already recevied an answer on how to do it. However,
With your current formulas you could do =TEXT(SUMPRODUCT(1*H2:H9),"[hh]:mm:ss") -- Regards, Tom Ogilvy "Tamara" wrote in message ... If this function works: =TEXT(F9-E9, "hh:mm:ss"), why doesn't this: =TEXT(H2:H9, "hh:mm:ss")? I have a form enter start and end times. In another column I use the first function above to calculate the elapsed time. I would like to total that column in hh:mm:ss format. How do I do this? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
Hi
you are probably looking for =TEXT(SUM(H2:H9), "[hh]:mm:ss") But why use the text function at all? simply use =SUM(H2:H9) and goto 'Format - cells' and use the custom format [hh]:mm:ss Reason: With the latter one you can use the result for further calculations. If you use TEXT you first have to convert the string to a numeric value before you could use it for further calculations! -- Regards Frank Kabel Frankfurt, Germany Tamara wrote: If this function works: =TEXT(F9-E9, "hh:mm:ss"), why doesn't this: =TEXT(H2:H9, "hh:mm:ss")? I have a form enter start and end times. In another column I use the first function above to calculate the elapsed time. I would like to total that column in hh:mm:ss format. How do I do this? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
since she used Text function to produce the results in H2:H9, using a
straight sum function will only return zero. I showed how to use sumproduct to convert them to summable values. -- Regards, Tom Ogilvy "FxM" wrote in message ... Hi Tamara, =TEXT( XXX , "hh:mm:ss") is only a way to show differently XXX. In first case, XXX is a difference. In second, H2:H9 is a group of cells. But what Excel needs to do with this group to give a result ? You indicated to search for a total : Does =TEXT(sum(H2:H9), "hh:mm:ss") answer your wish ? @+ FxM Tamara a écrit : If this function works: =TEXT(F9-E9, "hh:mm:ss"), why doesn't this: =TEXT(H2:H9, "hh:mm:ss")? I have a form enter start and end times. In another column I use the first function above to calculate the elapsed time. I would like to total that column in hh:mm:ss format. How do I do this? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How calculate end time with beginning time plus formula minutes | Excel Worksheet Functions | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) |