how can I count hours more than 24?

  • Thread starter Thread starter Sirritys
  • Start date Start date
S

Sirritys

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Hours over 24 hours in Access Report 0
extracting hours from a sum of time 1
How to totalize hours, even when the sum > 24? 1
Time format? 1
converting minutes into hours > 24 Hours 1
Time format, timesummary less than - 24 hours 2
count days hours and minutes 13
Subtracting 37 hours from a cell containing format [h]:mm 2

Back
Top