Figure out the hours worked for the week

Try formatting the cell as:
[h]:mm:ss
or
[hh]:mm:ss

Svetlana wrote:
>
> Could you help me if i need to Figure out the hours worked for the week
> Example:
>
> Start time Finish time Difference
> 10:05:00 18:40:00 8:35:00
> 20:00:00 04:05:00 8:05:00
> 15:20:00 00:45:00 9:25:00
> Total: ??
> When i do autosum Total is 02:05:00
>
> Thank you

--

Dave Peterson

Set the format of the totals cell to [hh]:mm to cater for more than 24
hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Svetlana" <Svetlana@discussions.microsoft.com> wrote in message
news:6F49248C-C37B-4CE3-9649-A1B52F450E3E@microsoft.com...
> Could you help me if i need to Figure out the hours worked for the week
> Example:
>
> Start time Finish time Difference
> 10:05:00 18:40:00 8:35:00
> 20:00:00 04:05:00 8:05:00
> 15:20:00 00:45:00 9:25:00
> Total: ??
> When i do autosum Total is 02:05:00
>
> Thank you
>

Try formatting the cell as:
[h]:mm:ss
or
[hh]:mm:ss

Svetlana wrote:
>
> Could you help me if i need to Figure out the hours worked for the week
> Example:
>
> Start time Finish time Difference
> 10:05:00 18:40:00 8:35:00
> 20:00:00 04:05:00 8:05:00
> 15:20:00 00:45:00 9:25:00
> Total: ??
> When i do autosum Total is 02:05:00
>
> Thank you

--

Dave Peterson

Set the format of the totals cell to [hh]:mm to cater for more than 24
hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Svetlana" <Svetlana@discussions.microsoft.com> wrote in message
news:6F49248C-C37B-4CE3-9649-A1B52F450E3E@microsoft.com...
> Could you help me if i need to Figure out the hours worked for the week
> Example:
>
> Start time Finish time Difference
> 10:05:00 18:40:00 8:35:00
> 20:00:00 04:05:00 8:05:00
> 15:20:00 00:45:00 9:25:00
> Total: ??
> When i do autosum Total is 02:05:00
>
> Thank you
>

Could you help me if i need to Figure out the hours worked for the week
Example:

Start time Finish time Difference
10:05:00 18:40:00 8:35:00
20:00:00 04:05:00 8:05:00
15:20:00 00:45:00 9:25:00
Total: ??
When i do autosum Total is 02:05:00

Thank you

Try formatting the cell as:
[h]:mm:ss
or
[hh]:mm:ss

Svetlana wrote:
>
> Could you help me if i need to Figure out the hours worked for the week
> Example:
>
> Start time Finish time Difference
> 10:05:00 18:40:00 8:35:00
> 20:00:00 04:05:00 8:05:00
> 15:20:00 00:45:00 9:25:00
> Total: ??
> When i do autosum Total is 02:05:00
>
> Thank you

--

Dave Peterson

Set the format of the totals cell to [hh]:mm to cater for more than 24
hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Svetlana" <Svetlana@discussions.microsoft.com> wrote in message
news:6F49248C-C37B-4CE3-9649-A1B52F450E3E@microsoft.com...
> Could you help me if i need to Figure out the hours worked for the week
> Example:
>
> Start time Finish time Difference
> 10:05:00 18:40:00 8:35:00
> 20:00:00 04:05:00 8:05:00
> 15:20:00 00:45:00 9:25:00
> Total: ??
> When i do autosum Total is 02:05:00
>
> Thank you
>