Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for adding up time intervals?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for adding up time intervals?
Col A = Start Time Col B = End Time Col C = Elapsed Time A3 =9:43 B3 =17:12 C3 =B3-A3 C20 =SUM(C3:C19)*24 Select Cell C20 and Format Cells General If start time is before midnight and end time is after midnight: e.g. end time is 2:00 a.m. enter end time as 26:00 -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=544958 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for adding up time intervals?
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? |
#4
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for adding up time intervals?
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formula for Time | Excel Discussion (Misc queries) | |||
Time formula | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Excel formula for a time sheet | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |