how can I count hours more than 24?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sirritys - 05 Oct 2006 06:03 GMT

Hi,

I'm trying to sum time fields up so I could get the total time I've
been working. The thing is that everytime the sum hits 24 hours it just
goes to 0 again. This way I only get X*24 + showing hours and I have no
idea what is total summ.

So how should I format cells to make it show for example "94:30" or
something similar

Yours,
Sirritys

Reply to this Message

Trevor Shuttleworth - 05 Oct 2006 06:07 GMT

Sirritys

Format as [hh]:mm

Regards

Trevor

> Hi,
>
[quoted text clipped - 8 lines]
> Yours,
> Sirritys

Reply to this Message

Sirritys - 05 Oct 2006 06:41 GMT

Thanks man,

Easier than I would have thought =)

Reply to this Message