Say login time is in A1, logout time in B1
='B1-A1)+(A1B1)
format hh:mm

The +(A1B1) copes with cases like login=23:00, logout=02:00

HTH
--
AP

"thinkrabbit" a écrit dans le
message de news: ...
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?