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...
PeterBartholomew1
Oct 27, 2020Silver Contributor
Irrespective of whether you use the workbook offered, the conversion form a 'time' duration (measured as fractional part of a day) to hours (as a decimal number) is
= 24 * time