function to add time totals over 24 hours

M

mikesteven

I have a total column that gives me the difference of start time to end time.
It is formatted as 13:30 in excel. I need to now add all the totals. I used
to have a function that would add the total hours once is went over 24. I
can't find it anymore. Can anyone help?

Thanks,

Mike
 
B

Barnabas

Hi Mike
I recently learnt this from this forum:

Format in-time and out-time columns in "13:30" mode
use this formula: mod(out_time - in_time,1)
which will give you the time diff. i.e., the no.of hrs worked.
You can total this column as usual.
I have adopted this now....thank to this forum
Barnabas
 

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

Adding Days and Hours 8
values > 24/48 hours 2
If Function With A Time 5
How do I summarize total hours over multiple days 5
How do I add hours and minutes without 24 hour limit 1
Subtracting time...again 2
Excel formula for adding up sub-totals in time format 2
Time Sheet Summary 1

Top