Forum Discussion
NathanSelvidge
Oct 27, 2020Copper Contributor
Time Out of 100 vs 60
Hello, I am looking for a very specific formula to solve all my problems. The program my work uses for time measures time in 60 minute ours (ex. 5:30pm closing time). Whenever an employee clocks in a...
NikolinoDE
Oct 27, 2020Platinum Contributor
Here is an old work of mine, so you can calculate the time in decimal, just enter the start and end time of the work,
The formula for that was this one down there.
Where U was intended for vacation, K for sick, FB for further training.
You can rearrange the shape as you like or use the inserted file right away, if you like.
Where U was intended for vacation, K for sick, FB for further training.
You can rearrange the shape as you like or use the inserted file right away, if you like.
=IF(OR(I11="U",I11="K",I11="FB"),$J$2,IF(J11<I11,((J11+1)-I11)*24,(J11-I11)*24))
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.