From science to arts, IDNLearn.com has the answers to all your questions. Discover in-depth and reliable answers to all your questions from our knowledgeable community members who are always ready to assist.

In Excel, to calculate the total number of hours worked using a 24-hour clock format, which formula would you use if you have start and end times in cells A1 and B1, respectively?
- =B1 - A1
- =TEXT(B1 - A1, "h:mm")
- =SUM(B1 - A1)
- =DATEDIF(A1, B1, "h")