formula for showing number of hours used in a work week

[ghynes]

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.

[veejar]

hi,

check whether the attached file works for you

Regards,

Veejar