Count work hours since joining date
Closed
Mohammed
-
Jun 10, 2010 at 04:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 10, 2010 at 04:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 10, 2010 at 04:26 AM
Hello,
How can i calculate in MS Excel number of worked hours if join date is available.
Ex: 1. cell A1 is joining date 12 March 2009
2. in cell B1 i want total worked hours since 12 March 2009 (let say working hours is 8 hours only)
How can i calculate in MS Excel number of worked hours if join date is available.
Ex: 1. cell A1 is joining date 12 March 2009
2. in cell B1 i want total worked hours since 12 March 2009 (let say working hours is 8 hours only)
Related:
- Count work hours since joining date
- Forex hours app for pc - Download - Finance
- How to count names in excel - Guide
- 72 hours block facebook image download - Facebook Forum
- You have hit the limit for sms codes. try again in 24 hours. ✓ - Facebook Forum
- Share your activity status by default when joining large servers - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 10, 2010 at 04:26 AM
Jun 10, 2010 at 04:26 AM
Get the difference between the dates, and multiply by 8
=(today() - A1) * 8
=(today() - A1) * 8