Adding up times

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raistlin - 02 Jan 2008 19:03 GMT

I have used the formula below to work out the amount of hours from a start
time to a finish time for each day.

Start - Finish - Total Hours

=TEXT(D3-C3,"h:mm:ss")

It works fine and give me the result but if I try to add the weeks hours I
get is 00:00:00.

Each sell has a formula which shows the correct times but the value shown
can not be used.

I hope this makes sense as it has got me beaten.

Any help would be appreciated.

Tia

Reply to this Message

Niek Otten - 02 Jan 2008 19:25 GMT

You can't add text.

Replace this:

=TEXT(D3-C3,"h:mm:ss")

with:

=D3-C3

and format Custom as "h:mm:ss"

Format the total as Custom:

[h]:mm:ss

This will prevent the sum from topping over at 24 hours

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have used the formula below to work out the amount of hours from a start
| time to a finish time for each day.
[quoted text clipped - 14 lines]
|
| Tia

Reply to this Message

Raistlin - 03 Jan 2008 14:27 GMT

Many thanks for your advice Niek

> You can't add text.
>
[quoted text clipped - 35 lines]
> |
> | Tia

Reply to this Message