How do I convert time recorded in a cell to total minutes?

[AlexD]

I've got a series of cells which calculates the time elapsed between 2 other cells. The time is displayed in the new cell, but I need the cell just to display the total number of minutes in decimal format. For example, I enter

Cell A1: 4:01
Cell B1: 8:05

Cell C1=B1-A1 yields 4:04.

It is my intention that these cells reflect minutes:seconds, not hours:minutes.

I'd like the 4:04 to read as 4.067 (minutes).

How do I do this?

Regards,
Alex

 

[Yogi Anand]

Hi Alex:

If 4:04 is in cell A1, then in B1 use

=A1*24 and Format it as Number 3 Decimal Places -- it should read 4.067

Regards!

Yogi
This message was edited by Yogi Anand on 2002-08-23 19:44

 

[AlexD]

Got it thanks. I also had to reformat the new cell to Number -> General which wasn't obvious to me at first.

Thanks again,
Alex