Hi all. My problem is I am trying to set up a data base with time in it. All columns are formatted to [hh]:mm and I need the final hours to be capped...eg
34:00hrs + 45:00hrs = 79hrs. But I need the final sum (79hrs) to be a maximum of 56:00hrs if above 56:00hrs, if below, the true sum to be shown..
Can anyone help me please!
Bookmarks