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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

just_jon

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

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,587
Members
412,327
Latest member
KLichter
Top