Jul 10 2020 10:07 AM
I work in manufacturing, and am trying to add to excel a minutes and second column for showing how long it takes to make each part for a full item. I am needing to be able to add up all of the minutes and seconds as well without them being in relation to a date or the 24 or 12 hour clock.. if that makes sense.
I have tried the mm:ss and mm:ss.0 but nothing works. I am not wanting to have to input hours as I don't need them.
Can anyone help?
Jul 10 2020 11:10 AM
Jul 10 2020 11:16 AM
As far as formatting, I think [m]:ss is what you're looking for. But, it appears excel still requires you to key the hour when you enter the data. So, you'd have to key a 0 placeholder (0:20:36 for 20 minutes, 36 seconds).
If the extra keying of the leading 0 is an issue from a data entry standpoint, maybe you could enter the data as a decimal (20.10 for 20 min 10 sec) and modify your summary formulas (depending on how you are using the data downstream and the desired format of the summary data)? I'm partial to this when keying a lot of time data as I can key it faster as a decimal than time.
I attached a workbook as an example.
Jul 10 2020 11:52 AM
Hi,
I'm not sure what you want but I think this is in the right direction ... see sheet.
Nikolino
Jul 10 2020 03:13 PM
Jul 12 2020 11:02 AM
i don't understand what is wanted.
81.20 decimal is 81min & 12 sec. this can be calculated with the formula and the correct line formatting (H1 = formula for line formatting - right mouse click).
You can use the formula in E1 to determine whether it should be added up or appear individually.
in H1 is the line formatting for E1
In E1 the formula is formatting for the calculation
Where is my mistake?