Solved

Time card calculation and Deltek Conversion

Posted on 2014-12-20
3
136 Views
Last Modified: 2014-12-21
I need to perform the conversion shown.  Assistance is greatly appreciated.
Deltek-Conversion.xlsx
0
Comment
Question by:frugalmule
  • 2
3 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 40511155
It isn't need what your question us

Your attachment has a spreadsheet with four columns with some date/time information.

There is also a graphic that shows a twelve-hour clock along with appears to be a picture of a tqable that could be used to convert minutes to decimal hours

How do these items relate?
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 40511160
I seem to have made some typographical errors. This version is somewhat of a correction:

"It isn't clear what your question is

Your attachment has a spreadsheet with four columns with some date/time information.

There is also a graphic that shows a twelve-hour clock along with what appears to be a picture of a table that could be used to convert minutes to decimal hours

How do these items relate? "
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40511187
I presume you wish the time intervals that are calculated in column C to be converted to decimal values.  Additionally, you want those values rounded to the nearest tenth (0.1) according to the graphic/table shown.

Insert the following formula in cell D2 and copy down as far as needed.  Ensure that the format of the cell is "General" or "Number" and not "Time").
=ROUNDUP(C2*24,1)

I've attached a modified copy of your example file with some additional time examples.

Regards,
-Glenn
EE-Deltek-Conversion.xlsx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now