Sum of elapsed time

G

Guest

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

Format for Time Elapsed in Decimal 4
Working with dates and time 5
Computing Elapsed Time 4
calculate time elapsed inbetween days 3
Calculate elapsed time excluding specific timeframe 10
Access Access - Elapsed Time between Records 5
Calculating Elapsed Time 2
Recording elapsed time 1

Top