Monday Formula to calculate overtime

Hi Sara,

If both times are on the same day, try:

LEFT({End Time#Minutes},2)-LEFT({Start Time#Minutes},2)+DIVIDE(MINUS(RIGHT({End Time#Minutes},2),RIGHT({Start Time#Minutes},2)),60)

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*

1 Like