I have a simple excel workbook, where cell values are being populated through another excel workbook's VBA modules. The values are simple times/days in format ddd [$-409]m/d/yy h:mm AM/PM;@ - start times, and end times.
In the attached Excel file, there is a Sheet for Fitter2 (in a workshop).
In Fitter2 sheet, job Start1 time is in Cell # E3, job Pause1 time is in Cell # F3.
I want to calculate the passed time in hours:minutes:seconds between these two dates.
FitterStatus sheet has the starting time of Fitter2, ending time of Fitter2, and his holiday plans. all these are named ranges, as F2ST, F2FT, HolidayList.
it is not working for some reason, and constantly giving me "#Value" error.
the formula i am trying to use is (used in F3)