Helo Expert,.
=SUMIF(C3:C5,"Car A",H3:H5)
Need help to sum this function in 24 hours.
Please refer attachment.
Thanks.
Helo Expert,.
=SUMIF(C3:C5,"Car A",H3:H5)
Need help to sum this function in 24 hours.
Please refer attachment.
Thanks.
you have had almost 50 views and no replies. That tells me that members dont understand what you are asking for (I know I dont), and making a statement like "Note: I want the total hour to count up to 24 hours, the hour will reset to 0 after 24 hours" in your file is very confusing.
Perhaps try to explain in more detail, and show a sample of what your answer would look like?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
cap1.JPG
sory,.
Actually, i want the outcome in total hour (red column) = 330 hour. This it the sum of 'Car A' C3 + C5 ,.
At least i know u all viewing & try to help,. (",) ,.
Please look at the attached file. Format in K3 is [h]mm.
Last edited by Andreus; 07-19-2014 at 02:12 AM.
Eureka !!! Well done,.
Tq Guy,.
It seems the same function but the amazingly u got the different and correct result,. Can u explain it why,. ? (",) ,.
It's not the formula. Select the cell K3, click <CTRL+1> for the dialog box Format Cells, select the Number tab, in the Category field select Custom.
thanks,. 5***** for u ,.
the solving is inside file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks