Kyauta Mai Canza Sa'o'i zuwa Adadi
Canza tsakanin lokacin HH:MM da adadin sa'o'i don biyan albashi da jadawalin lokaci, tare da zagayewa.
Canza lokutan HH:MM zuwa adadin sa'o'i (da baya) don biyan albashi da jadawalin lokaci. Ƙara jimillar shigarwa da yawa kuma yi amfani da zagayewar biyan albashi — duk a cikin burauzar ku.
Shigarwa ɗaya a kowane layi: 8:30, 8h 30m, 8.5, 9:00-17:30, 9am-5:30pm ko 22:00-06:00. Ƙara hutu da - 30 ko (30).
Ana cirewa daga layukan farawa-ƙarewa da ba su da nasu hutu.
Ginshiƙin mintuna zuwa sa'o'i masu ƙima
| Mintuna | Daidai | Goma (0.1) | Kwata (0.25) |
|---|---|---|---|
| :00 | 0.00 | 0.0 | 0.00 |
| :01 | 0.02 | 0.0 | 0.00 |
| :02 | 0.03 | 0.0 | 0.00 |
| :03 | 0.05 | 0.1 | 0.00 |
| :04 | 0.07 | 0.1 | 0.00 |
| :05 | 0.08 | 0.1 | 0.00 |
| :06 | 0.10 | 0.1 | 0.00 |
| :07 | 0.12 | 0.1 | 0.00 |
| :08 | 0.13 | 0.1 | 0.25 |
| :09 | 0.15 | 0.1 | 0.25 |
| :10 | 0.17 | 0.2 | 0.25 |
| :11 | 0.18 | 0.2 | 0.25 |
| :12 | 0.20 | 0.2 | 0.25 |
| :13 | 0.22 | 0.2 | 0.25 |
| :14 | 0.23 | 0.2 | 0.25 |
| :15 | 0.25 | 0.3 | 0.25 |
| :16 | 0.27 | 0.3 | 0.25 |
| :17 | 0.28 | 0.3 | 0.25 |
| :18 | 0.30 | 0.3 | 0.25 |
| :19 | 0.32 | 0.3 | 0.25 |
| :20 | 0.33 | 0.3 | 0.25 |
| :21 | 0.35 | 0.3 | 0.25 |
| :22 | 0.37 | 0.4 | 0.25 |
| :23 | 0.38 | 0.4 | 0.50 |
| :24 | 0.40 | 0.4 | 0.50 |
| :25 | 0.42 | 0.4 | 0.50 |
| :26 | 0.43 | 0.4 | 0.50 |
| :27 | 0.45 | 0.5 | 0.50 |
| :28 | 0.47 | 0.5 | 0.50 |
| :29 | 0.48 | 0.5 | 0.50 |
| :30 | 0.50 | 0.5 | 0.50 |
| :31 | 0.52 | 0.5 | 0.50 |
| :32 | 0.53 | 0.5 | 0.50 |
| :33 | 0.55 | 0.6 | 0.50 |
| :34 | 0.57 | 0.6 | 0.50 |
| :35 | 0.58 | 0.6 | 0.50 |
| :36 | 0.60 | 0.6 | 0.50 |
| :37 | 0.62 | 0.6 | 0.50 |
| :38 | 0.63 | 0.6 | 0.75 |
| :39 | 0.65 | 0.7 | 0.75 |
| :40 | 0.67 | 0.7 | 0.75 |
| :41 | 0.68 | 0.7 | 0.75 |
| :42 | 0.70 | 0.7 | 0.75 |
| :43 | 0.72 | 0.7 | 0.75 |
| :44 | 0.73 | 0.7 | 0.75 |
| :45 | 0.75 | 0.8 | 0.75 |
| :46 | 0.77 | 0.8 | 0.75 |
| :47 | 0.78 | 0.8 | 0.75 |
| :48 | 0.80 | 0.8 | 0.75 |
| :49 | 0.82 | 0.8 | 0.75 |
| :50 | 0.83 | 0.8 | 0.75 |
| :51 | 0.85 | 0.9 | 0.75 |
| :52 | 0.87 | 0.9 | 0.75 |
| :53 | 0.88 | 0.9 | 1.00 |
| :54 | 0.90 | 0.9 | 1.00 |
| :55 | 0.92 | 0.9 | 1.00 |
| :56 | 0.93 | 0.9 | 1.00 |
| :57 | 0.95 | 0.9 | 1.00 |
| :58 | 0.97 | 1.0 | 1.00 |
| :59 | 0.98 | 1.0 | 1.00 |
🔒 Ana canza komai a cikin burauzar ku — ba a loda komai zuwa sabar.
Yadda Yake Aiki
Canja lokutan HH:MM zuwa awoyi decimal da baya, tara wani jerin lokuta, kuma yi amfani da zagayarwar biyan kuɗi (kwata-awa, goma-awa ko mafi kusa minti). Cikakke don timesheets da biyan kuɗi — duk a burauzarka.
- 1Zaɓi alkiblaLokaci → decimal, ko decimal → lokaci.
- 2Shigar da lokutankaHH:MM guda a kowace layi; ana tara su gareka.
- 3Zaɓi zagayarwaBabu, mafi kusa kwata, goma ko minti.
- 4Karanta sakamakoDecimals a kowace layi da jimla da aka zagaya.
Komai ana canjawa a burauzarka — babu wani da ake loda shi.
Kayan Aiki Masu Alaƙa
Na'urar Lissafin Zaben Lokaci
Zaben lokaci na mako-mako tare da farawa/ƙarewa/hutu na kowace rana, jujjuya kan tsakar dare, ƙarin lokaci na FLSA ko California da jimillar albashi. Ana ajiyewa a burauzarka, fitar da CSV. Kyauta, sirri, babu tallace-tallace.
Mai Ƙididdige Katin Lokaci
Ƙara lokutan shiga/fita na agogon yau da kullum da hutu marasa biya don jimlar awoyin aikinka na mako, tare da zaɓin overtime bayan awoyi 40 da albashin gaba ɗaya daga adadin sa'a.
Mai Ƙididdige Lokaci
Ƙara ko cire tsawon lokaci na HH:MM:SS, ko nemo lokacin da ke tsakanin timestamps biyu. Yana da amfani don rubuce-rubucen aiki, splits na tsere, da bin diddigin ayyuka.