lorenzo999999
New member
- Joined
- Dec 17, 2012
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hello,
after two days of searching and testing, I'm still at the starting point, please, could you help me to find the right solution?
I searched all over the forum but there is nothing that matches.
The problem:
From a date to be entered (dd: mm: yy (cell B2)) and (hh: mm: ss (cell C2)), I have 1407000sec (cell D2) (this time is generated by other calculations) to perform a task.
The task can be performed 7/7 but from 10:00 to 00:00. (24h time format)
Desired result:
1) turn my known second in format dd: hh: mm: ss (cell D3) knowing that the working time / day is 14 hours (7/7 from 10:00 to 0:00) to know how much time the task will occupy.
2) To know the exact date (dd: mm: yy (cell B3)) and the exact time of end (hh: mm: ss (cell C3)) of the task.
Thank you in advance for your kind heart.
Lorenzo
after two days of searching and testing, I'm still at the starting point, please, could you help me to find the right solution?
I searched all over the forum but there is nothing that matches.
The problem:
From a date to be entered (dd: mm: yy (cell B2)) and (hh: mm: ss (cell C2)), I have 1407000sec (cell D2) (this time is generated by other calculations) to perform a task.
The task can be performed 7/7 but from 10:00 to 00:00. (24h time format)
Desired result:
1) turn my known second in format dd: hh: mm: ss (cell D3) knowing that the working time / day is 14 hours (7/7 from 10:00 to 0:00) to know how much time the task will occupy.
2) To know the exact date (dd: mm: yy (cell B3)) and the exact time of end (hh: mm: ss (cell C3)) of the task.
Thank you in advance for your kind heart.
Lorenzo