Thread: Calculates date and time

I have this formula, which calculates a time (cells D16 - D19) and submit it
along with what time it is right now (-TIME (23, 59, 59), and then I get a clock at all, for when the task is ready

My formel:
= IF ((MOD (NOW (); 1) + MAX (D16: D19))> TIME (23, 59, 59); ((MOD (NOW (); 1) + MAX (D16: D19))-TIME (23, 59, 59) + TIME (0, 0, 1)), MOD (NOW (); 1) + MAX (D16: D19))

The formula used in cell F20 in my spreadsheet that is attached to this post.


I can now see here after I've taken it into use, it is not enough merely to count forward to what my clock production of raw materials is completed, but also need a date in front.

I can also see that what happens is that if the cells D16 to D19 exceeds 24 hours, the figure in cell F20 misleading.

My wish is that if they exceeded 24 hours, will also be informed on what date. For example. "July 4 12:24:59" but if there are less than 24 hours are only disclosed an hour.

is this possible ??

Or how can I take a cell (H16) with the information = time:minuts:second ( 32:14:24) and
merging/add it with what the time is right now and show it in date, hour, minute, seconds (celle H20)?