Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

number of seconds to minutes and seconds

Status
Not open for further replies.
matpj

matpj

Technical User
Mar 28, 2001
687
GB
Hi,

I have a number in a field that I want to convert to minnutes and seconds.
how is this possible?

eg. number - 66
minutes/ seconds = 01:06

does anyone have any ideas?
 
Sort by date Sort by votes
Try this:

=INT(A1/60)&":"&MOD(A1,60)

gives you the result 1:6

I have assumed that 66 is in cell A1 and its in seconds. You want to get the minutes and seconds, which is why I have divided by 60.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bhujanga
  • Locked
  • Question
Prevent Converstion of Long Numeric Strings to Exponential Format 1
Replies
4
Views
204
remeng
remeng
R
  • Question
Issues with Outlook default account and performance
Replies
0
Views
200
radleymartinez
R
cneill
  • Locked
  • Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
342
cneill
cneill
Rick_Stanich
  • Locked
  • Question
Find the nth occurrence of a string and report value to the left. 1
Replies
5
Views
121
Rick_Stanich
Rick_Stanich
pendle666
  • Locked
  • Question
Microsoft Word - removing index entries with find/replace and wildcards
Replies
4
Views
1K
pendle666
pendle666

Part and Inventory Search

Sponsor

Back
Top