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

gluonman · #8 03-22-2017, 04:58 PM

Quote:

That's fine.
It may not at all be a problem, but be aware that your preferred solution doesn't allow for times to cross midnight (for example 2200, 2300 2330 and 130 in A1, B1, C1 and D1 respectively).
(and the decimal values problem is just to multiply the value in K9 with 24 and format K9 as General).

Thanks for the additional tip. I had failed to consider that case, and turns out that will be a problem for me, so I'm going to see about modifying my solution a bit more to account for that.

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