Calculated Work Hours With Formula in Excel

-

 Calculated Work Hours With Easy Formula

We can calculate the hours worked by deducting the end time from the start time. The information has to be entered into Excel in a correct time format for the formula to work


 



The formula C3-B3 will give us the percentage of the day worked based on 24 hours in a day. To get the hour worked, we need to multiply this value by 24.


Comments

Post a Comment

If you have doubt Pl Let me know

Popular posts from this blog

-
Comfort & Healing Peaceful Music, Mediation Music............................Must Listen music for your Comfort  
Read more

How to Make a Checklist in Excel-Checklist

-
Image
  Inserting a   checkbox in Excel   is easy. For example, use checkboxes to create a checklist or a dynamic chart. You can also insert a   check mark   symbol. Insert a Checkbox To  insert a checkbox , execute the following steps. 1. On the Developer tab, in the Controls group, click Insert. 2. Click Check Box in the Form Controls section. 3. For example, draw a checkbox in cell B2. 4. To remove "Check Box 1", right click the checkbox, click the text and delete it. Link a Checkbox To link a checkbox to a cell, execute the following steps. 1. Right click the checkbox and click Format Control. 2. Link the checkbox to cell C2. 3. Test the checkbox. 4. Hide column C. 5. For example, enter a simple IF function. 6. Uncheck the checkbox. Note: read on for some cool examples. Create a Checklist To create a checklist, execute the following steps. 1. Draw a checkbox in cell B2. 2. Click on the lower right corner of cell B2 and drag it down to cell B11. 3. Right click the first checkbox
Read more