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-22-2017, 08:26 PM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

You are aware that the solution I provided does account for the crossing midnight problem?

Tags

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 05:39 PM.