TIME

  • Thread starter Thread starter Boyertown Casket
  • Start date Start date
B

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.
 
Back
Top