Thread: Minutes and Seconds
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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


Reply With QuoteReply With Quote