Custom Format Cell to reflect actual minutes

[ExcelDummy77]

I'm creating a workbook for work. This includes dates and times...

The formula is created in D94. It is titled Fibrinolytic Time. I want to have the time read 90 rather than 1530. The formula is supposed to be B71+B74-C20+C55. When I did the format cell in "Time" it states 1:30. I did a custom format cell for D94 using [mm] and it state 1530. Is there a custom format for it to state the actual minutes rather than 1:30 or 1530.

Thanks!!

[mehmetcik]

Use this formula instead:-

Please Login or Register  to view this content.

Then use the general format

[ExcelDummy77]

Works great! Thanks mehmetcik!