Calculate time machine run time in minute

Dear All Guru,

Anyone able to help me to calculate the time different in minute my machine running on the daily basis. My mind blank unable to think of any formula suitable to be used. Sorry for asking novice question as i just a basic user of excel and willing to learn more. Guru please teach me. Attached the file for your references.

Hi,

if machine operations end before midnight, you could try in B8 to be copied to the right

=B7*60+C7-B6*60-C6

Hope it helps

Canapone said:

Hi,

if machine operations end before midnight, you could try in B8 to be copied to the right

=B7*60+C7-B6*60-C6

Hope it helps

Click to expand...

Yes,its really helpful.

Thank You, Guru. I can now continue to develop my excel worksheet to calculate the machine OEE.

If i still encounter problems, i will post it here to be shared.

Regards
Kenny