Converting 9/30/04 16:30 to minutes only
 

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

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


Thanks!! :cool

--
LC2
-----------------------------------------------------------------------
LC22's Profile: http://www.excelforum.com/member.php...fo&userid=1488
View this thread: http://www.excelforum.com/showthread.php?threadid=26517

Converting 9/30/04 16:30 to minutes only
 

You can use a custom format. In the cell that you want to read

7 days and 0 hours and 16 minutes

format the date as Custom (instead of date as it is currently) and use the
following:
d "Days," h "Hours and" mm "Minutes"

Hope this helps...

"LC22" wrote:


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!! :cool:


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

Converting 9/30/04 16:30 to minutes only
 

Multiply the result of your calculation by 1440 (the number of minutes in a
day) and then format it as a Number, not a Date/Time.

--
George Nicholson

Remove 'Junk' from return address.


"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!! :cool:


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

Converting 9/30/04 16:30 to minutes only
 

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!! :cool:


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

Converting 9/30/04 16:30 to minutes only
 

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!! :cool:


--
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

Converting 9/30/04 16:30 to minutes only
 

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!! :cool:


--
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