Adding time

[PuckMark19]

I'm guessing this is fairly simple, but I cannot figure it out. Apologies in advance.

I have a fairly simple spreadsheet where I am calculating cycle and run times for an operation. Normal run times are anywhere from 2-10 minutes. When the operator enters a run time in a cell, they have to type in 0:4:34 (or 12:04:34 AM), or else it returns something other than the correct value. Is there a way to format the cell where the hours field does not need to be entered? I'd love for them to just type in 4:34 in the field.

Thanks for any assistance you can provide.

 

[Dave Patton]

What version of Excel are you using?
Can you provide examples of your challenge?

Total is Custom Formatted [h]:mm
I just typed 4:34 etc
With rows 6 and 7, I custom formatted data areas [h]:mm before entering the numbers

T202110a.xlsm
	A	B	C	D	E
1
2
3	10:44			04:34	06:10
4	26:32			20:22	06:10
5
6	10:44			4:34	6:10
7	52:32			20:22	32:10
8
3a

Cell Formulas
Range	Formula
A6:A7,A3:A4	A3	=SUM(D3:E3)

 

[PuckMark19]

That worked perfectly. Thanks so much!