Sum of elapsed time

K

KarenR

I set up a worksheet to track time spent at a particular website by individual users. Time is shown in 24 hours time (for instance - time in = 13:18, time out = 13:35); final column is elapsed time (formula: SUM (E2-D2)). Is there a way for the elapsed time column to total beyond 24:00 (24 hours)? I can subtotal up to 24 hours, but then it resets and begins again. I need to be able to show time spent over a month and it almost always is more than 24 hours. Thanks for your help to a real Excel "newby".
 
F

Frank Kabel

Hi Karen
format the target cell with the custom format [hh]:mm (goto Format -
Cells - Custom). this will prevent the rollover after 24 hours
 

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

Computing Elapsed Time 4
Format for Time Elapsed in Decimal 4
Help with calculating time and a half - I've got straight time and double time. 4
calculate time elapsed inbetween days 3
Calculate elapsed time excluding specific timeframe 10
Working with dates and time 5
Subtracting time...again 2
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0

Top