TIME IN MINUTE FORMAT ONLY

WELLS4WATER

New Member
Joined
Nov 22, 2005
Messages
2
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

Legend
Joined
Sep 3, 2002
Messages
10,473
Welcome to MrExcel - you mean something like this?
Book4
ABCD
117:4512:10
2Format 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.
 

Forum statistics

Threads
1,077,829
Messages
5,336,647
Members
399,094
Latest member
Learner2019

Some videos you may like

This Week's Hot Topics

Top