Calculating Difference Between Two Times in General Format
Suppose
A1 = 2257 (formated as text)
B1 = 2253 (formated as text)
Try the below formula in C1 (formatted as hh:mm)
=TIME(INT(LEFT(A1,2)-LEFT(B1,2)),INT(RIGHT(A1,2)-RIGHT(B1,2)),0)
If this post helps click Yes
---------------
Jacob Skaria
"MGranger" wrote:
I am using a google document survey to have users enter times in a military
format. The result is pasted into excel as a "General" format number, like
2253 to represent 10:53PM. They do not enter the semicolon between hours and
minutes.
I need to see the number of minutes between two times, such as 2257 - 2253
or 4 minutes.
How can I convert general numbers, some of which are 04 to represent 00:04
AM, to serial times or time format?
Thanks very much in advance.
|