Forum Discussion

AdinelB's avatar
AdinelB
Copper Contributor
Feb 06, 2023
Solved

Time range between a certain time range and how many hours of that certain range

Hello, everybody   I'm trying to automate our employee entries and I faced the following problem. So if Employee 1 is working rom 12:00 to 20:00, theoretically it's a 8 hours program so it's no ov...
Formulas and Functions
office 365
  • Hiawathado's avatar
    Hiawathado
    Copper Contributor
    Jan 19, 2025

    Sir,

    I hate you! You simplified my "code" with your solution so badly. So I needed to rewrite my sheets. And now it looks so clean and clear.

    Thank you! 😂

  • AdinelB's avatar
    AdinelB
    Copper Contributor
    Feb 06, 2023
    Sir,
    You just saved me big times. I've been working really hard the last few hours on it.

    Thanks a lot!

Resources