30 minute time intervals openoffice excel

Press 'Enter' to complete the formula, then right-click on the cell and choose 'Format Cells.' Select 'General' from the list on the left side of the window, then click 'OK.' This cell will now show your time interval in a decimal form instead of a time form. Click 'OK' to close the window.Ĭlick on cell 'B2' and enter the following formula: This particular time format will display more than 24 hours in the 'hours' part of the time, allowing you to display time intervals longer than one day. Click on 'Time' from the column on the left side of the window that pops-up, then slick on '37:30:55' from the list of time formats on the right side of the window. Right-click on cell 'B1' and choose 'Format Cells' from the pop-up menu. Without this code, the formula will error out in such times. The 'If' statement will cover those times when your starting time is later then your ending time, such as when you start counting at 10 PM and finish at 4 AM. Select cell 'A2' and enter your ending time using the same format as you did for the starting time.Ĭlick on cell 'B1' and enter in the following formula:

Enter this time as either the hours and minutes, like 'hh:mm,' or as the date plus the time, like 'mm/dd/yy hh:mm.' You can also choose to add ':ss' to the end of the times if you need to enter seconds as well, but note that these will not display in the cell.

Click on cell 'A1' and type in your starting time.

30 minute time intervals openoffice excel