💻 Software
Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Fresh5 days ago
Mar 15, 20263350 viewsConfidence Score0%
0%
Problem
I'm trying to develop an Excel formula that would calculate the actual time duration for a string of a time range of the following format: According to this article it seems it should be as simple as subtracting the two times. For example, to get the hours, minutes, and seconds between two times (4…
Error Output
=TEXT(B2-A2,"h:mm:ss")
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
Low Risk
Here's one of the complicated solutions. It's probably best just to paste this in and hope for the best rather than trying to sit down and parse this. Edit: Fixed the formula for the last time. Addressing comment: To add these output, to add a range…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix