Ask Your Question

Need to calculate a future date [closed]

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

Bjork gravatar image

updated 2012-07-20 03:51:05 +0200

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 01:41:39.055264

1 Answer

Sort by » oldest newest most voted

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

JohnSUN gravatar image

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

image description

edit flag offensive delete link more


Thank you very much for your response worked perfectly

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

Question Tools


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

Seen: 470 times

Last updated: Jul 20 '12