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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
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
725
RodneyW
R
S
  • Question Question
Conditional formatting embedded within formula
Replies
3
Views
132
dreid1011
dreid1011
R
  • Solved
Round to nearest
Replies
4
Views
102
Joe4
Joe4
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
71
Kaper
Kaper
C
  • Solved
Getting Minutes from time when rolling over to next day
Replies
5
Views
382
cknnugget
C

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

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