Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing up hours spent on jobs
I am trying to track time spent on jobs and I have my hours totaled using the
following format: =TEXT(D5-C5,"h:mm") However, Now I want to total all these numbers and cannot figure out the format to do that. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing up hours spent on jobs
So it sounds like the start time is in col C, the end time in D, and
the elapsed time in another column, maybe E. In your elapsed time formula you're using the TEXT function, which performs the math but then converts the result to a text entry for formatting. That's why you don't see results when you try to sum the elapsed time: it's all letters. As a workaround, you can sum the end times in column D, sum the start times in C, subtract C from D to get elapsed time, and apply the TEXT function again, perhaps something like this: =TEXT(SUM(D5:D21)-SUM(C5:C21),"h:mm") Will that do the trick? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing up hours spent on jobs
=TEXT(D5-C5,"h:mm")
That formula is returning a TEXT string. You should use this formula: =D5-C5 And format the cell as h:mm Then, to get the total from a range: =SUM(.........) And format that cell as [h]:mm Biff "kayti57" wrote in message ... I am trying to track time spent on jobs and I have my hours totaled using the following format: =TEXT(D5-C5,"h:mm") However, Now I want to total all these numbers and cannot figure out the format to do that. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
how do I calculate hours spent x an hourly rate? | Excel Worksheet Functions | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
Summing hours | Excel Worksheet Functions | |||
How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions |