Posted to microsoft.public.excel.misc
|
|
what is the formula for adding up time intervals?
Typo:
C1: ='B1-A1)+(A1B1)
C100=SUM(C1:C99)
format [h]:mm
HTH
--
AP
"Ardus Petus" a écrit dans le message de news:
...
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?
|