Need Help Counting Time In Excel

[Reephdweller]

I'm trying to come up with a formula in Excel that will calculate time.
Below is a screencap and a link to the file itself. On the lines that say "Total Time" I want to have a formula that will calculate the time from when the agent logged in and then logged out. I need it to appear in hours and minutes. In the spreadsheet attached I manually put in the total times, but I want to make something that calculates it for me. Any excel experts out there that can help me with this?

http://www.osirusonline.com/time.zip

http://www.osirusonline.com/times.gif

[silera]

I can't explain it but if you email me the file i'll do it for you tomorrow or at least try.

[Reephdweller]

I just PM'd you. Thanks.

[IMSlacker]

Can't you just subtract the login time from the logout time? What am I missing?

http://i148.photobucket.com/albums/s25/IMSlacker/leadlog1.png

http://i148.photobucket.com/albums/s25/IMSlacker/leadlog2.png

[Reephdweller]

Can't you just subtract the login time from the logout time? What am I missing?

http://i148.photobucket.com/albums/s25/IMSlacker/leadlog1.png

http://i148.photobucket.com/albums/s25/IMSlacker/leadlog2.png


OK, I see where you're going with this - but how do I then total up all those times in the total hrs column?

[IMSlacker]

OK, I see where you're going with this - but how do I then total up all those times in the total hrs column?

Use the sum formula from the second screen cap. =SUM(B7:G7)

[zentraed]

Just to add a little to IMSlacker...

If your logout times are going to go past midnight then you'll need to do a little more than just a simple subtraction. For example, a login at 5 PM, and logout at 1 AM would yield 1 AM - 5 PM = - 16 hours, but it should be 8 hours.

A quick fix is to use the formula = MOD(D6 - D5, 24). An IF statement can also be used, but modular arithmetic is way cooler :wink:

[IMSlacker]

Ohhh, of course. I knew there was something I was missing. Thanks, zentread.