24-hour Format
Entries
Total Hrs (24-hour)
Original by hgrmty on Discord
if(empty(prop("Start")) or empty(prop("End")), toNumber(""), round(((toNumber(slice(prop("End"), 0, 2)) - toNumber(slice(prop("Start"), 0, 2))) * 60 - toNumber(slice(prop("Start"), length(prop("Start")) - 2, length(prop("Start")))) + toNumber(slice(prop("End"), length(prop("End")) - 2, length(prop("End"))))) / 60 * 100) / 100)
AM/PM Format
Entries
Total Hrs (AM/PM)
Original by esrch on Reddit
if(empty(prop("In")) or empty(prop("Out")), toNumber(""), round((toNumber(replaceAll(prop("Out"), ":.*", "")) % 12 * 60 + toNumber(replaceAll(prop("Out"), "(^.*:)|( .*)", "")) + if(test(slice(prop("Out"), length(prop("Out")) - 2), "pm|PM|Pm|pM"), 12 * 60, 0) - (toNumber(replaceAll(prop("In"), ":.*", "")) % 12 * 60 + toNumber(replaceAll(prop("In"), "(^.*:)|( .*)", "")) + if(test(slice(prop("In"), length(prop("In")) - 2), "pm|PM|Pm|pM"), 12 * 60, 0))) / 60 * 100) / 100)
