Excel: calculate period between dates 论题张贴者: Samuel Murray
| Samuel Murray 荷兰 Local time: 09:11 正式会员 (自2006) English英语译成Afrikaans南非语 + ...
Hello Suppose I have two columns of dates & times in Excel, how can I calculate the time difference between the two columns? So, cell A1 = "28/01/2011 17:57" and cell A2 = "01/07/2011 11:14". According to an online calculator, the time difference is 154 days 17 hours 17 minutes. I don't care in what format the answer is given: days/hours/minutes, hours/minutes, hours, minutes, seconds, etc., as long as I can see the difference. I tried convert... See more Hello Suppose I have two columns of dates & times in Excel, how can I calculate the time difference between the two columns? So, cell A1 = "28/01/2011 17:57" and cell A2 = "01/07/2011 11:14". According to an online calculator, the time difference is 154 days 17 hours 17 minutes. I don't care in what format the answer is given: days/hours/minutes, hours/minutes, hours, minutes, seconds, etc., as long as I can see the difference. I tried converting the dates to computer time (you know, offset from 1970) but could not figure out how. Thanks Samuel ▲ Collapse | | | Tomasz Sienicki 丹麦 Local time: 09:11 正式会员 (自2007) Danish丹麦语译成Polish波兰语 + ... A simple subtraction | Nov 17, 2021 |
=A2-A1 …works for me. | | | Michael Davies 丹麦 Local time: 09:11 正式会员 (自2009) Danish丹麦语译成English英语 + ... | Daryo 英国 Local time: 08:11 Serbian塞尔维亚语译成English英语 + ... Differences in resolution .... | Nov 18, 2021 |
Samuel Murray wrote: Hello Suppose I have two columns of dates & times in Excel, how can I calculate the time difference between the two columns? So, cell A1 = "28/01/2011 17:57" and cell A2 = "01/07/2011 11:14". According to an online calculator, the time difference is 154 days 17 hours 17 minutes. I don't care in what format the answer is given: days/hours/minutes, hours/minutes, hours, minutes, seconds, etc., as long as I can see the difference. I tried converting the dates to computer time (you know, offset from 1970) but could not figure out how. Thanks Samuel converting time from an Excel cell to computer time might require some serious tinkering: the operating system counts time in milliseconds (or even with a 100ns resolution), Excel time is counted by whole seconds. Even the simple "time difference between 2 Excel cells" is not always so "simple" - you have to be careful not to get results with a meaningless precision. | |
|
|
Platary (X) Local time: 09:11 German德语译成French法语 + ...
Samuel Murray wrote: I tried converting the dates to computer time (you know, offset from 1970) but could not figure out how. Have a look here : https://www.epochconverter.com/ In Excel (2016) it corresponds to = (Cellwithhumandate-DATE(1970;1;1))*86400 Could be different formulas, I use this one when needed. Hope this helps! | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Excel: calculate period between dates Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
| Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |