Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets)

		Microsoft Office Forums > Microsoft Excel > Excel
Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets)

03-21-2017, 11:51 AM

trevorc

Windows 7 32bit Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets)

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

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

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
subtract date and time and convert to decimal hours ?	DBenz	Excel	5	01-26-2017 05:38 AM
Formula for decimal hours from two date time entries	DBenz	Excel Programming	0	01-15-2015 05:52 AM
Help! Need VBA solution to create CSV file and export to Google Calendar	mister_audioman	Excel Programming	0	01-12-2012 01:07 PM
Converting decimal to hours	jhwtsang	Excel	4	05-16-2011 01:36 PM
Convert hours in decimal	ghostones	Excel	1	12-29-2009 09:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:06 AM.