TIME

[Boyertown Casket]

I have a cell (D5) called 'Elapsed Time On-Clock' with the corresponding
answer being in a cell (D6) containing the following formula:
=MOD(1+C983-C922,1)

I need to retain this answer in this separate cell (D6); however, I would
like to then convert the result in cell (D6) to minutes and have this result
appear in an adjoining cell (D7). For example: The answer in cell (D6) is
1:20. I would like cell (D7) to contain the result of 80 minutes.

How would I write the formula?

Thank you.

 

[JE McGimpsey]

Since XL stores date/times as fractional days:

D7: =D6*1440