Forum Discussion
Solved
Wrong Value Returned When Using A Calculated Time
Hello All! I am attempting to create a simple timesheet that will automate processes to save some time. I am running into an issue when I multiply my rate column by my hour column. To calculate t...
One option is to make the hours formula return decimal hours:
=24*MOD([@[End Time]]-[@[Start Time]],1)
Format the cells with this formula as Number or as General.
Another option is to leave the hours column as time, and to multiply the end result with 24:
=24*[@[Total Hours]]*20
One option is to make the hours formula return decimal hours:
=24*MOD([@[End Time]]-[@[Start Time]],1)
Format the cells with this formula as Number or as General.
Another option is to leave the hours column as time, and to multiply the end result with 24:
=24*[@[Total Hours]]*20
Thank you! I tried both out and both worked great! very much appreciated!