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

[LC22]

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

 

[Guest]

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

 

[George Nicholson]

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.

 

[Tom Ogilvy]

do a custom number format on the cell.

format it as

[mm]

or

[mm:ss]

 

[Dave Peterson]

Typo alert <bg>:

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

do a custom number format on the cell.

format it as

[mm]

or

[mm:ss]
--
Regards,
Tom Ogilvy

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

 

[Tom Ogilvy]

Yep, thanks.

--
Regards,
Tom Ogilvy

Typo alert <bg>:

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

do a custom number format on the cell.

format it as

[mm]

or

[mm:ss]
--
Regards,
Tom Ogilvy

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's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14886
View this thread: http://www.excelforum.com/showthread.php?threadid=265177