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
Delete fake facebook account within 24 hours ✓ - Facebook Forum
How to delete my friend Facebook fake account? - Facebook Forum
Delete Fake Facebook Account - Facebook Forum
Count sentences ✓ - Programming Forum
Forex hours app for pc - Download - Finance

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

Counting cells containing only numbers

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

How to delete fake Facebook account

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

Can't join WhatsApp group chat

Similar discussions

Subscribe To Our Newsletter!