TIME IN MINUTE FORMAT ONLY

[WELLS4WATER]

Hi,
I'm trying to format cells in minutes only. But the max seems to be 59. Is there any way to format in minutes?

Thank you,
Susan

 

[just_jon]

Welcome to MrExcel - you mean something like this?

Book4
	A	B	C	D
1	17:45	12:10	335
2			Format as number, 0 decimals
Sheet1

Remember that time - anything less than a day - is stored as a decimal, so the # of minutes in a day [ 24 hrs x 60 min/hr ] times the fraction will yield minutes.

EDIT for typos.

 

[WELLS4WATER]

Thank you - you made that look really easy!!!

Susan