![]() ![]() =A1-B1 gets the difference in days and #VALUE if there is text in the calculation:Ģ.25 as unformatted number if the difference is 2.25 (2 days and 6 hours) Villeroy wrote:Cell formatting is completely irrelevant as long as your values are numbers. ![]() 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 days hour minutes softwareI 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |