Calculate total working hour

To calculate time and date in Excel, you can use various functions and formulas:

1. **Current Date and Time:**
- To display the current date: Use the formula `=TODAY()`.
- To display the current time: Use the formula `=NOW()`.

2. **Adding or Subtracting Time:**
- To add days to a date: Use `=A1 + n` (where A1 is the cell with the date and n is the number of days to add).
- To subtract days from a date: Use `=A1 - n`.

3. **Calculating Time Difference:**
- To find the difference between two dates: Use `=A2 - A1` (where A2 and A1 are the cells with dates).

4. **Formatting Date and Time:**
- Right-click on the cell, select "Format Cells," and choose the desired date or time format from the Number tab.

5. **Extracting Date and Time Components:**
- To extract the year from a date: Use `=YEAR(A1)`.
- To extract the month from a date: Use `=MONTH(A1)`.
- To extract the day from a date: Use `=DAY(A1)`.
- To extract the hour from a time: Use `=HOUR(A1)`.
- To extract the minute from a time: Use `=MINUTE(A1)`.
- To extract the second from a time: Use `=SECOND(A1)`.

Replace A1 and A2 with the appropriate cell references or values based on your specific Excel sheet.
Waqar zaka
Salman khan