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

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)

Count work hours since joining date
Excel count occurrences - Guide
Count names in excel - Guide
Share your activity status by default when joining large servers - Guide
Forex market hours desktop widget - Download - Finance
72 hours block facebook image download - Facebook Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 10, 2010 at 04:26 AM

Get the difference between the dates, and multiply by 8

=(today() - A1) * 8

Similar discussions

you have requested too many SMS codes. you must wait 24 hours to receive another

Uh-oh... You have reached your SMS limit for 24 hours.

After waiting for 24 hours still respecting too many code

Counting cells containing only numbers

Couldn’t request an sms code after 24 hours passed Instagram

Similar discussions

Subscribe To Our Newsletter!