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".
 
Ad

Advertisements

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
 
Ad

Advertisements


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

Top