Help

[gayanwin]

machan time eka 16.16/ 16.17/ 16.18........16.29 wenakan type kala a time eka 16.15 widhata watenna formula ekak kiyahanko

a kiyanne machan 16:29 nam 16:15
16:30 = 16:30
16:31 = 16:30

onna ohima

 

[lilman]

Up

 

[gayanwin]

up

 

[Tharaka_x]

 

[Gwynbleidd]

let interval = 15 * 60 * 1000;  // 15min in ms
let myDate = new Date(); // date that should be round to nearest 15min

// date with nearest 15min
let newDate = new Date(Math.round(myDate / interval) * interval);

oke round kiyana ekata floor dammama hariyai. danna ekek kiyayi, mn me internet eken gtte

 

[Rapunzel003]

Bump

 

[Candid-B]

Excel වල =IF function එකෙන්වත් කරන්න බෑ බන්. ඔතන time formatting නිසා තවත් අවුල්.

 

[Any.key]

bump

 

[kinkon]

 

[newbie22]

ask chatgpt