Hi!

Just subtract:

Log out - Log in

A1 = 9:43
B1 = 17:12

=B1-A1

If the log out time might span past midnight:

A1 = 9:43 PM
B1 = 5:43 AM

=B1-A1+(B1<A1)

Or

=MOD(B1-A1,1)

Format as [h]:mm

Biff

"thinkrabbit" wrote in message
...
i am trying to set up a way to add up how much time was spent on particular
sessions with my business using millitary time. for example person X
logged
into a machine at 9:43 and logged out at 17:12. is there a way to
calculate
this using excel?