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
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
Try...
=A1+B1
...and custom format cell as [hh]:mm
Hope this helps!
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks