Calculate time till my Holiday

I

Intruder

I want to calculate the time till my holiday in days,hours,minutes and seconds.
I've got this formula from internet it works well, but i want to get my breakes out of it.
How do I do this?

Thanks in advance!


STARTTIME= 07:30:00
FIRST_BREAK= 09:30:00
END_FIRST_BREAK= 09:45:00
SECOND_BREAK= 12:30:00
END_sECOND_BREAK= 13:00:00
ENDTIME= 16:15:00
LAST_WORKDAY_2004= 23-07-2004



=IF(INT(TODAY())=INT(LAST_WORKDAY_2004);ROUND(24*(LAST_WORKDAY_2004-TODAY());2);(24*((ENDTIME-STARTTIME))*(MAX(NETWORKDAYS(TODAY()+1;LAST_WORKDAY_2004-1;0);0)+INT(24*(((LAST_WORKDAY_2004-INT(LAST_WORKDAY_2004))-(TODAY()-INT(TODAY())))+((ENDTIME-STARTTIME)))/(24*((ENDTIME-STARTTIME)))))+REST(ROUND(((24*(LAST_WORKDAY_2004-INT(LAST_WORKDAY_2004)))-24*(STARTTIME))+(24*(ENDTIME)-(24*(TODAY()-INT(TODAY()))));2);ROUND((24*((ENDTIME-STARTTIME)));2))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate time elapsed inbetween days 3
microsoft office web components wizard in office 2010 0
Time calculation "challenge" 4
Subtracting hours and minutes with negative times 3
Calculate time difference 3
<<Extracting the desired data with an formula>> 10
How to sum negative times 2
UDF To Calculate Work hours between two dates Problem with code 4

Top