Hi
You are calculating the daytime worktime. (Lets call it D2) could you use
=B2-C2-D2?
Regards
David Grugeon
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles
Dear LJ,
Can you share a sample workbook with us for more clarity.
On Sun, Aug 26, 2012 at 11:51 PM, LJ wrote:
> *Greetings!*
> *
> *
> *I currently use the formula below to calculate the total time to
> complete a task between 6AM and 7PM (13-hour workday). I need to reverse
> the formula to c
