Struggling to calculate working hours? Or difference between two times? What about the difference between time zones?

In this video, we’ll show you how to calculate the time difference between two times in Excel.

Here’s the logic

1. Subtract the future time by the past time.
2. Multiply that by 24.
3.Add, in parenthesis the date in the future time by the past time.
4. Multiply that by 24.
5. &/”Hours/” to add hours to your amount of time

Your formula will look a little bit like this.

=(D15-D14)24+(C15-C14)*24&/”Hours/”

LIKE + SUBSCRIBE FOR THE BEST SPREADSHEET TIPS ON THE YOUTUBES

#calculatetimedifference #exceltips #excelformulasandfunctions

…

GET ACCESS TO 100+ Dynamic Excel Spreadsheet Templates

https://www.simplesheets.co/

Project Management
Marketing
Supply Chain and Operations
Small Business
Human Resources ‍‍
Data Analysis ‍
Accounting
Finance

These templates empower you to use Excel to streamline all your personal and business needs.

Customizable
Dynamic
Designed
Formatted
‍ Instructions and Videos
Reporting Visuals

Get 5 FREE Templates When You Sign Up

https://www.simplesheets.co/kanban
https://www.simplesheets.co/plan-do-c…
https://www.simplesheets.co/gantt-chart
https://www.simplesheets.co/saas-metr…

Want to new skills that improve your income, marketability, and expertise?

Our Excel University has 48+ lectures to help you master Microsoft Excel.

https://www.simplesheets.co/excel-uni…

We’ll walk you through everything you need to know to be an Excel Expert

Lookups
Functions
Formulas
Charts and Graphs
Dashboards

Please take the opportunity to connect and share this video with your friends and family if you find it useful.