Yep, thanks.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
Typo alert <bg:

Instead of:
[mm:ss]
try:
[mm]:ss



Tom Ogilvy wrote:

do a custom number format on the cell.

format it as

[mm]

or

[mm:ss]
--
Regards,
Tom Ogilvy

"LC22" wrote in message
...

Is there a way to subtrace 9/8/04 16:30:00 from 9/15/04 16:46:00 and
in
the resulting cell have it display minutes only?

If so, how? Currently, I can subtract the dates but it displays the
days, hours and minutes in that data format so it'd be: 1/7/00 00:16
to
mean 7 days and 0 hours and 16 minutes.


Thanks!!


--
LC22

------------------------------------------------------------------------
LC22's Profile:
http://www.excelforum.com/member.php...o&userid=14886
View this thread:
http://www.excelforum.com/showthread...hreadid=265177


--

Dave Peterson