Calculate number of weeks , days and hours from milliseconds

Question

There were many similar questions around but none addressed this calculation. Using javascript i it is easy to find the number of milliseconds diff b/w 2 dates for ex:

var mil = Math.floor(new Date("1/1/2012")  - new Date("1/7/2012"))

mil is assigned 518400000

to get weeks i would do below

var weeks = mil / (1000*7*24*60*60);

in the above example it exactly fits 1 week. For other possible inputs i would like to get output as ex:

n Weeks, y days , z hours

So i did mil % (1000*7*24*3600) to get the modulus and from the remainder calculate number of days. but astonishingly this was answer i got from console 1 weeks , 6 days seems the week calculated before is also accounted for days again.

How should i calculate these correctly?

Mike Samuel · Accepted Answer · 2014-05-31T13:12:30.057

12

var seconds = (mil / 1000) | 0;
mil -= seconds * 1000;

var minutes = (seconds / 60) | 0;
seconds -= minutes * 60;

var hours = (minutes / 60) | 0;
minutes -= hours * 60;

var days = (hours / 24) | 0;
hours -= days * 24;

var weeks = (days / 7) | 0;
days -= weeks * 7;

Assuming mils is non-negative, this leaves mils in the range [0, 1000), leaves minutes and seconds in the range [0, 60), leaves hours in the range [0, 24), and leaves days in the range [0, 7).

edited May 31 '14 at 13:12

answered Feb 23 '12 at 05:01

Mike Samuel

118,113
30
216
245

this was more perfect of calculation i quickly put a JSBin and it works thanks http://jsbin.com/usigit/4/ – Deeptechtons Feb 23 '12 at 05:27
could you improve this version to include Years and Months for completeness. – Deeptechtons Feb 23 '12 at 05:33
@Deeptechtons, no. Months and years are not equal in length. – Mike Samuel Feb 23 '12 at 06:03
i certainly do agree ;) i tried a hand but it had become more complex due to Leap years, unequal days in month. If only all months had 30 days LOL – Deeptechtons Feb 23 '12 at 06:55
@Deeptechtons, yeah. The history of [calendar reform](http://en.wikipedia.org/wiki/Calendar_reform#Proposals) is a long and frustrating one though :) – Mike Samuel Feb 23 '12 at 14:15

score 6 · Answer 2 · answered Feb 23 '12 at 04:59

There should be 6 days between them, not one week. Your weeks calculation needs to round down:

var weeks = Math.floor(mil / (1000 * 7 * 24 * 60 * 60));

Also, your milliseconds are negative; you want either

var mil = new Date("1/7/2012") - new Date("1/1/2012");

or

var weeks = Math.floor(Math.abs(mil) / (1000 * 7 * 24 * 60 * 60));

Calculate number of weeks , days and hours from milliseconds

How should i calculate these correctly?

2 Answers2

Linked