Thread: Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets)
View Single Post
 
Old 03-21-2017, 11:51 AM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default Another sample for you
Check out this sample, uses autocalc and conditional formatting to provide correct totals, red squares go away only when everything is correct.
Attached Files
File Type: xlsx Casual Time sheet - Copy.xlsx (28.1 KB, 15 views)
Reply With Quote