Minutes and Seconds

[mattc66 via OfficeKB.com]

Hi All,

I want to format my cells for minutes and seconds. The issue I am having is
its for our phone bill. So I have hundred of minutes that I want to show.
When I use the mm:ss it changes it to hours. How do I just display the total
minutes and seconds.

Example: 4474 minutes and 18 seconds (4474:18)

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200901/1

 

[RagDyer]

Try:

[mm]:ss

 

[Mike H]

Try

[mm]:ss

Mike

 

[Gary''s Student]

Format the cell as Custom [mm]:ss
Enter data as 0:4474:18

You still need the hours part for data entry

 

[mattc66 via OfficeKB.com]

When I do that and enter 974 minutes and 22 seconds it changes it 58462:00.
What am I doing wrong?

Try:

[mm]:ss

Hi All,

[quoted text clipped - 9 lines]

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200901/1

 

[mattc66 via OfficeKB.com]

That did it! Thanks

Format the cell as Custom [mm]:ss
Enter data as 0:4474:18

You still need the hours part for data entry

Hi All,

[quoted text clipped - 7 lines]

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200901/1

 

[mattc66 via OfficeKB.com]

I should have asked with this post, but would you know then how I would
calculate the cost per minute.

Example: 0:4474:18 cost $282.78 how would I calculate the cost per minute?

Format the cell as Custom [mm]:ss
Enter data as 0:4474:18

You still need the hours part for data entry

Hi All,

[quoted text clipped - 7 lines]

Thanks
Matt

 

[Mike H]

you need to enter 0 for the hours


h m s
0:99999:21

Mike

When I do that and enter 974 minutes and 22 seconds it changes it 58462:00.
What am I doing wrong?

Try:

[mm]:ss

Hi All,

[quoted text clipped - 9 lines]

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200901/1

 

[John]

Hi
Try this
Custom Format your cells [mm]:ss and when you enter your figure type
0:2250:12 for 0 hour 2250 minutes 12 seconds, p.s. Don't forget the square
brackets around the minutes
HTH
John

 

[RagDyer]

With 282.78 in A1, and minutes in B1, try this in C1:

=A1/(B1*1440)

Make sure C1 is formatted to Number!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


try

I should have asked with this post, but would you know then how I would
calculate the cost per minute.

Example: 0:4474:18 cost $282.78 how would I calculate the cost per minute?

Format the cell as Custom [mm]:ss
Enter data as 0:4474:18

You still need the hours part for data entry

Hi All,

[quoted text clipped - 7 lines]

Thanks
Matt

 

[mattc66 via OfficeKB.com]

Thanks that worked.

With 282.78 in A1, and minutes in B1, try this in C1:

=A1/(B1*1440)

Make sure C1 is formatted to Number!

I should have asked with this post, but would you know then how I would
calculate the cost per minute.

[quoted text clipped - 10 lines]

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200901/1

 

[Ragdyer]

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Thanks that worked.

With 282.78 in A1, and minutes in B1, try this in C1:

=A1/(B1*1440)

Make sure C1 is formatted to Number!

I should have asked with this post, but would you know then how I would
calculate the cost per minute.

[quoted text clipped - 10 lines]

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200901/1