FG
💻 Software

How to calculate hours and minutes between two time periods?

Fresh5 days ago
Mar 15, 202634857 views
Confidence Score0%
0%

Problem

I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods. I have a field: which could be for example: 08:30 Then I have a field which could be for example: 12:30 I can easy calculate the result myse…

Error Output

timestart

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to calculate hours and minutes between two time periods?

Low Risk

Mestika, It sounds like you already know how to calculate the values - it sounds like you need help formatting the results. Typically Excel uses a value of 1 to represent a day. (e.g. 6 hours would be 0.25) You should be able to subtract two times (…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment