| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minutes and Seconds
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.a...excel/200901/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
Try:
[mm]:ss -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mattc66 via OfficeKB.com" <u16013@uwe wrote in message news:9048edf5a2549@uwe... 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.a...excel/200901/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
Try
[mm]:ss Mike "mattc66 via OfficeKB.com" wrote: 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.a...excel/200901/1 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
Format the cell as Custom [mm]:ss
Enter data as 0:4474:18 You still need the hours part for data entry -- Gary''s Student - gsnu2007k "mattc66 via OfficeKB.com" wrote: 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.a...excel/200901/1 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
When I do that and enter 974 minutes and 22 seconds it changes it 58462:00.
What am I doing wrong? RagDyer wrote: 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.a...excel/200901/1 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
That did it! Thanks
Gary''s Student wrote: 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.a...excel/200901/1 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
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? Gary''s Student wrote: 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 http://www.officekb.com |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
you need to enter 0 for the hours
h m s 0:99999:21 Mike "mattc66 via OfficeKB.com" wrote: When I do that and enter 974 minutes and 22 seconds it changes it 58462:00. What am I doing wrong? RagDyer wrote: 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.a...excel/200901/1 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
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 "mattc66 via OfficeKB.com" <u16013@uwe wrote in message news:9048edf5a2549@uwe... 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.a...excel/200901/1 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
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 "mattc66 via OfficeKB.com" <u16013@uwe wrote in message news:90492b7d80a9b@uwe... 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? Gary''s Student wrote: 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 http://www.officekb.com |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
Thanks that worked.
RagDyer wrote: 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.a...excel/200901/1 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Minutes and Seconds
You're welcome, and appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mattc66 via OfficeKB.com" <u16013@uwe wrote in message news:9049db8813205@uwe... Thanks that worked. RagDyer wrote: 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.a...excel/200901/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
| Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
| Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
Linear Mode
