Soluții

Calculare diferente de timp in Excel

Daca aveti rapoarte in care vreti sa calculati diferenta de timp intre doua timpuri secunde/minute/ore va trebui sa facem urmatorul lucru.

Numarul 86400 poate fi folosit pentru a converti timpul in secunde.

Ca si explicatie simpla pentru acest numar avem asa:

  • Fiecare zi are 24 de ore.
  • Fiecare ora poate fi inteleasa ca procent din numarul total de ore ale zilei.
  • Procentul poate fi folosit pentru a gasi secundele:

01:00 = 1/24

02:00 = 2/24

03:00 = 24/3

Explic putin de unde vine numarul 86400:

Sa zicem ca avem ora 15:00. Asta inseamna: 15:00 * 86400 = 54000. 15 ore sunt egale cu 54000 de secunde.

15:00 este 15/24 (0,625).

0.625 * 86400 = 54000

Inmultiti pentru a obtine 86400. Si asa rezulta : 24 (ore) * 60 (minute) * 60 (secunde) = 86400

[mai mult...]

How to Auto-Silence Calls and Alerts During Apple Watch Workouts

If you set up a Focus for Fitness on your iPhone, you can automatically silence calls and alerts on your Apple Watch when you begin a workout. This article explains how it’s done.

Often when you’re working out, the last thing you want to receive is a phone call, message, or other alert that pulls you out of your flow. Fortunately, Apple includes a Fitness Focus that you can easily set up so that nothing distracts you from achieving your immediate fitness goals during a workout.

Follow the steps to set up your Fitness Focus.

[mai mult...]

How to silence unknown callers in WhatsApp

Unsolicited phone calls are a regular annoyance and even a cause of stress for many smartphone users these days. Thankfully, iOS includes an option to automatically silence calls to your iPhone from unknown numbers, and now you can do the same for calls you receive via WhatsApp, too.

WhatsApp announced a new Silence Unknown Callers feature for the encrypted messaging platform in June 2023. The company says it is designed to automatically screen out spam, scams, and calls from unknown people for increased protection.

[mai mult...]