?
Solved

Time card calculation and Deltek Conversion

Posted on 2014-12-20
3
Medium Priority
?
159 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

752 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