Time card calculation and Deltek Conversion

I need to perform the conversion shown.  Assistance is greatly appreciated.
Deltek-Conversion.xlsx
frugalmuleAsked:
Who is Participating?
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
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
 
GrahamSkanRetiredCommented:
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
 
GrahamSkanRetiredCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.