Alguien podría compartirme las fórmulas del progreso de la hora y el progreso del Minuto?
Soy nueva en el foro.
Gracias
TRANSLATION
Could someone share the formulas for the progress of the hour and the progress of the minute?
I’m new to the forum.
Thanks.
Hi there,
I am not sure if this is going to be a solution to your need… but you could use the Time Span function to calculate the duration (the span of time) between 2 time.
SYNTAX
$tf(endTime – beginTime, timeFormat)$
EXAMPLES
Calculate between today at 11:30:10 and today at 12:40:00
$tf(dp(12h40m0s)-dp(11h30m10s), "h 'hour(s)', m 'minute(s)', s 'second(s)'")$
➞ Calculate the duration between 2 time: 11:30:10 am and 12:40:00 pm, and display it as … hour(s), … minute(s), … second(s)
NOTES
- tf(…) is the Time Span function
- dp(…) is the Date Parser function
TIPS
Date & time formats (case sensitive in the writing):
- YEAR: y ➞ “yy”: 25 | “yyyy”: 2025
- MONTH: M ➞ “M”: 6 | “MM”: 06 | “MMM”: Jun | “MMMM”: June
- DAY: d ➞ “d”: 1…9, 10…31 | “dd”: 01…09, 10…31
- WEEKDAY: E ➞ “E”: Sun | “EEEE”: Sunday
- HOUR: h ➞ “h”: 0…9, 10…24 (in 24-hour time format) | “hh”: 00…09, 10…24
- MINUTE: m ➞ “h”: 0…9, 10…59 | “hh”: 00…09, 10…59
- SECOND: s ➞ “h”: 0…9, 10…59 | “hh”: 00…09, 10…59
- AM/PM: a ➞ “a”: AM or PM (in 12-hour time format)
I hope this would help.
1 Like