hello all,

anyone know a formula that would show me the number of hours from start of workweek (Monday 7am) until whenever a workbook is opened during that week?

Thanks.