Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing up time
I need help in summing up time . Guy A worked for 11:45 in day 1 , then worked for 10:50 in day 2. How can sum up guy A's total worked hours for 2 days. the sum should be 22:35. Please help -- egamalaki ------------------------------------------------------------------------ egamalaki's Profile: http://www.excelforum.com/member.php...o&userid=23858 View this thread: http://www.excelforum.com/showthread...hreadid=375020 |
#2
|
|||
|
|||
With Day 1's time worked in A1 and Day 2's time worked in A2
Total time worked is =A1+A2 Format using a Custom Format as elapsed time [h]:mm PC "egamalaki" wrote in message ... I need help in summing up time . Guy A worked for 11:45 in day 1 , then worked for 10:50 in day 2. How can sum up guy A's total worked hours for 2 days. the sum should be 22:35. Please help -- egamalaki ------------------------------------------------------------------------ egamalaki's Profile: http://www.excelforum.com/member.php...o&userid=23858 View this thread: http://www.excelforum.com/showthread...hreadid=375020 |
#3
|
|||
|
|||
Just add them up:
=A1+A2 or =sum(a1:a2) And a custom format of: [hh]:mm will show the total hours/minutes. egamalaki wrote: I need help in summing up time . Guy A worked for 11:45 in day 1 , then worked for 10:50 in day 2. How can sum up guy A's total worked hours for 2 days. the sum should be 22:35. Please help -- egamalaki ------------------------------------------------------------------------ egamalaki's Profile: http://www.excelforum.com/member.php...o&userid=23858 View this thread: http://www.excelforum.com/showthread...hreadid=375020 -- Dave Peterson |
#4
|
|||
|
|||
Try... =A1+B1 ...and custom format cell as [hh]:mm Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=375020 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing Time Data | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
unmet challenge | Excel Worksheet Functions | |||
Summing Time | Excel Discussion (Misc queries) | |||
Summing Time | Excel Discussion (Misc queries) |