Previous Topic Next Topic

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)
Related:

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

Instagram not updating people I follow total
Rayinado -
HelpiOS -

1 response
Banned fb account
Hamza -
Shaxiya -

2 responses
you have requested too many SMS codes. you must wait 24 hours to receive another
Meyusake -
HelpiOS -

3 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Couldn’t request an sms code after 24 hours passed Instagram
Khaled_6368 -
haileyhargett.. -

1 response