Premium Only Content
![Calculate total working hour](https://1a-1791.com/video/s8/6/2/T/r/S/2TrSm.qR4e.1.jpg)
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
-
43:13
BonginoReport
4 hours agoSuper Bowl Vibe Shift: Trump Cheered, Taylor Swift Booed (Ep.136) - 02/10/2025
76.8K111 -
LIVE
Wendy Bell Radio
5 hours agoThe Rats Are Scrambling
15,228 watching -
1:26:34
Jeff Ahern
2 hours ago $1.60 earnedMonday Madness with Jeff Ahern( put a fork in them)
13.2K2 -
42:43
Dad Dojo Podcast
8 hours ago $0.71 earnedEP19: Cashing In Crypto
17.5K -
2:30:07
TheDozenPodcast
21 hours agoEpstein island, fake news, Royal Family scandal: Dan Wootton
14.4K5 -
LIVE
The Pete Santilli Show
4 hours agoRASKIN THREATENS CLASS ACTION TO STOP MUSK. BERNIE LIES TO THE PUBLIC ABOUT DOGE [EP 4434-8AM]
1,137 watching -
10:31
Space Ice
23 hours agoHardcore Henry - A Average Day In The Life Of Space Ice - Best Movie Ever
19.9K22 -
8:03
Colion Noir
22 hours agoA Judge Just Ruled You Can Own A Machine Gun
30.1K55 -
46:13
Survive History
23 hours ago $1.06 earnedCould You Survive in the Roman Special Forces?
18.8K -
19:40
Fit'n Fire
23 hours ago $0.26 earnedThe Best PDW -- Sig Sauer MPX 8" PDW
10.7K4