Helo Expert,
Note:
When total 'sum' up to certain amount the 'total sum' will reset.
Refer attached .xlsx file.
Please help to solve (",) ,.
Helo Expert,
Note:
When total 'sum' up to certain amount the 'total sum' will reset.
Refer attached .xlsx file.
Please help to solve (",) ,.
Last edited by karamaianguy; 01-22-2015 at 02:14 AM.
Try using a costume format on the total cell:Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
not work,.
Plzzzzzzzzzzzzzzz help,.
Last edited by karamaianguy; 01-22-2015 at 04:01 AM.
Not entirely sure of the intention of your formula/e, but the simple formula:formatted asFormula:Please Login or Register to view this content.shows 768:21, your expected result.Formula:Please Login or Register to view this content.
Regards, TMS
or =TEXT(SUM(F4:F174),"[hh]:mm")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Note thatwill display the value you expect, but it will be a left aligned text value, rather than a number representing a time (number of hours)Formula:Please Login or Register to view this content.
See the updated example.
Regards, TMS
Thanks Guys,.
Look likes i need to simplify my function,. (",) ,.
Great job,. !!
Cheers,
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks