hello all
can someone pls advice.
i need to calculate the time between start to finish dates.
A1
08/07/05 12:00
A2
09/07/05 1200
i found this formula =text(a2-a1,"h:mm") to be helpful.
but i want to calculate business hours only which is from 9am to 5:30.
can someone pls advice what formula i can use?
thanks
Bookmarks