Thread: Minutes and Seconds
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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


Reply With QuoteReply With Quote