I interprete your statement from a service operation point of view in the way that you enter all data
7/2/14 16:49 Fazlu Alamin-2 7/2/14
You have the chance to enter both date and time information into one cell like
click into the cell and type
14/07/02 16:49 enter. Note that with between …/02 and 16:4… there is a space. To see the date and time information you need to format the cell.
A possible format is
yyyy-mm-dd hh:mm In this case your cell will show 2014-07-02 16:49. Note that also in the cell format there is a space between …-2014 and hh:m…
For the date format you can choose what ever suits you and the date entry could still be as indicated
Now the formula to calculate the downtime depends on how your machine downtime is defined in your service agreement. In the most simple case where the downtime clock counts 24h in a full day you just can use the following arrangement in your spreadsheet:
A2 = start date and time (in format explained about)
B2 = name of your maintenance team
C2 = end (restore) date and time (in format explained about)
D2 = Downtime based on 24h downtime per day, Saturdays, Sunday and National Holidays included.
The formula in D2 needs to be:
=C2-A2 and the format of D2 needs to be
The result should look like this:
If you want/need to enter the date and time in different cells, than calculation becomes more complex. In this case I recommend to have a look into the free manual, which you can download here: http://www.libreoffice.org/get-help/documentation/ and come back here if you still have questions.
Calculating downtimes based on normal business hours (e.g. 09:00-18:00) is possible as well it is possible to incl/exclude weekends and holidays. Formula can become pretty complex and depend on the way you need to calculate the down time.