seconds to minutes

P

pavan5

Board Regular
Joined
Jun 13, 2017
Messages
56
I'm trying to convert seconds to minutes in excel 2013, tried this by a2/86400 and then formatting the cell but it is not giving me desired result, I need something like this..
cell A2 cell B2
0 1
1 1
2 1
3 1
...
58 1
59 1
60 2
...
3599 59
3600 60 minutes and then back to 1 from next number so on
 
Sort by date Sort by votes
pavan5 said:
81st second = 1.35 this should be considered as 2 but this is show as 1
146th secont = 2.46 this should be considered as 3 but this is shown as 2
Click to expand...

81st second is 1 minute 21 seconds. I think you're confused by the .35 (that doesn't represent 35 seconds, that represents 35 out of 100).
 
Upvote 0

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
dreid1011 said:
81st second is 1 minute 21 seconds. I think you're confused by the .35 (that doesn't represent 35 seconds, that represents 35 out of 100).
Click to expand...

ahhh, now I got it thanks !! yes all this while am looking at the .35 part and not the 29th or 30th second after the full minute...thanks much !! appreciate your help
 
Upvote 0
pavan5 said:
ahhh, now I got it thanks !! yes all this while am looking at the .35 part and not the 29th or 30th second after the full minute...thanks much !! appreciate your help
Click to expand...

You're welcome. Happy to help :)
 
Upvote 0
[TABLE="width: 848"]
<colgroup><col><col span="3"><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]SECONDS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]MINUTES[/TD]
[TD]SECONDS[/TD]
[TD]SECSUNDER30[/TD]
[TD]SECSOVER29[/TD]
[TD]REQMINS[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]21[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]95[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]35[/TD]
[TD]NO[/TD]
[TD]YRS[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 8"]A SIMPLE SET OF HIDDEN HELPER COLUMNS WOULD HAVE BEEN "EASIER" IN THE LONG RUN…..[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
pavan5 said:
could u tell me the formula for the same but can neglect the rounding part, I mean if it does not make full minute just take the minutes part and neglect the rounding
Click to expand...

never mind , I got it, learning it by trial and error , thank you !!
 
Upvote 0
pavan5 said:
could u tell me the formula for the same but can neglect the rounding part, I mean if it does not make full minute just take the minutes part and neglect the rounding
Click to expand...

Do you want to see it as minutes:seconds? Or ignore the seconds?
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Formatting time - minutes and seconds NOT time of day
Replies
2
Views
674
RodneyW
R
L
  • Question Question
radio buttons determining cell values with 2 sets of equations, the first half of the formula works, but second half doesn't
Replies
1
Views
51
Kaper
Kaper
C
  • Solved
Getting Minutes from time when rolling over to next day
Replies
5
Views
379
cknnugget
C
D
  • Question Question
Rounding Negative time to the nearest minute in Excel
Replies
4
Views
680
Scott Huish
Scott Huish
R
  • Question Question
Three-lane Stopwatch?
Replies
7
Views
770
RaymondW
R

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top