Little help?
I am trying to create a table for entering times worked on a shift system to be calculated in hours.
I have two fields, Start & End, which are formatted to General date so they have the date and time stored.
I have tried the basic calculation End - Start but some shifts finish after midnight.
PLEASE does anyone know the formula that I can enter into the Hours calculated field to get the data I need. I have looked online but can't seem to get the right result.
Many Thanks
I am trying to create a table for entering times worked on a shift system to be calculated in hours.
I have two fields, Start & End, which are formatted to General date so they have the date and time stored.
I have tried the basic calculation End - Start but some shifts finish after midnight.
PLEASE does anyone know the formula that I can enter into the Hours calculated field to get the data I need. I have looked online but can't seem to get the right result.
Many Thanks