#OPENOFFICE CALCULATE TIME DIFFERENCE SOFTWARE#

My problem goes like this I would like to be able to calculate the difference in time between 2 different dates more specific, I would like to calculate the number of hours let's say between the Offer Request I receive and the Answer I send to the customer those are my 'datas':Ĭolumn A ( offer request time ) | Column B ( sent answer time )Ĭell format type: date, format DD.MMM.YYYY HH:MM:AM/PM | date, format DD.MMM.YYYY HH:MM:AM/PMĬell display form: 14.Oct.2009 16:00:PM | 15.Oct.2009 10:30:AMĬan someone please let me know what formula should i use in order to calculate the difference between those dates ? For now, I must say that I do not specially care about the form of the result meaning that it can be calculated in hours form ( like 38 hours for example )or like day form ( 1day: 2 hours: 36 minutes for example ) anyway any suggestion will be highly appreciated what I get when trying to make the pure difference between 2 dates ( = B2-A2 ) is #VALUE! - and the status bar information is '' Error: Wrong data type' I format the cells in both number and date format and have the same result I tried a function like =Now()-cell and received a value but hard to understood I tried DAY and DATE functions but with the same result ( Error ) what I think is that there is more like a combination of functions that should be used and I did not liked the math at all during my school I like to mention that I did some research on the forum and didn't fount out quite what I expected as a solution however I did tried some solutions without any luck

#OPENOFFICE CALCULATE TIME DIFFERENCE SOFTWARE#

I am using OOo 3.0 on Ubuntu 9.04 - Jaunty and I come across to a point when I need some support for the CALC software

Openoffice calculate time difference