Ask Your Question

Ferdaus's profile - activity

2018-03-16 04:31:33 +0200 received badge  Nice Question (source)
2014-08-18 13:32:47 +0200 received badge  Famous Question (source)
2014-08-12 14:40:30 +0200 answered a question Trying to subtract two cells with Date & Time input together

Thanks a lot It used to work ok. I am having the problems very recently. I'll give this a try and come back

2014-08-11 19:26:14 +0200 received badge  Notable Question (source)
2014-08-11 16:37:46 +0200 received badge  Popular Question (source)
2014-08-11 16:12:03 +0200 received badge  Student (source)
2014-08-11 09:29:47 +0200 received badge  Editor (source)
2014-08-11 09:27:41 +0200 asked a question Trying to subtract two cells with Date & Time input together

Hi

I am using LibreOffice Calc Version: 4.2.4.2

My issue is that while trying to subtract two cells with Date & Time input together, I get

Fault Date & Time in NMS;   OSP;    Maintenance Team;   Restore Date & Time in NMS; Total Downtime
7/2/14 16:49                Fazlu   Alamin-2            7/2/14 21:22                30:04:33

The "Total Downtime" is formatted as (DD\hh:mm). The result should only be 4:33 Hrs:Mins

What am I doing wrong here:

Thanks Ferdaus