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)

FAQ

Thread Tools

Display Modes

03-21-2017, 11:06 AM

Pecoflyer

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

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

I must admit I did not read the entire explanation
Does the attached put you on track?

Attached Files

Time calc.xlsx (9.7 KB, 13 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

convert times to decimal, military time, total hours

« Previous Thread | Next Thread »

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 01:29 AM.