asked 2012-07-20 03:49:55 +0200

Bjork
11 ● 3

In Calc, I need to calculate a date that is a period of days in the future. Example if the dates 07/19/2012 6:48 I need to calculate what date time is 20 days, 12 hours, 10 minutes and 36 seconds from that time.

I can not figure out how to do this.

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

answered 2012-07-20 06:53:36 +0200

JohnSUN

2373 ● 2 ● 23 ● 37
http://wmstrong.ru/

Try to add DD+(HH+(MM+SS/60)/60)/24

image description

link delete flag offensive edit

Comments

Thank you very much for your response worked perfectly

Bjork ( 2012-07-20 20:40:35 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-07-20 03:49:55 +0200

Seen: 112 times

Last updated: Jul 20 '12

Need to calculate a future date