How do I change a employee time card from calculating in military time to standard time? Example:
EXAMPLE: 39852 8.25 16.75 0.5 =E11-C11-F11
0.34375 0.197916666666667 :30 8
DAY DATE START FINISH LESS LUNCH TOTAL HRS
SUN
MON 40042 8 16.5 0.5 =E15-C15-F15
TUE 40043 8 16.5 0.5 =E16-C16-F16
WED 40044 8 17 1 =E17-C17-F17
THU 40045 8 16.5 0.5 =E18-C18-F18
FRI =E19-C19-F19
SAT =E20-C20-F20
SUB-TOTAL HOURS (ROUNDED TO NEAREST .25) =SUM(G15:G20)
I'm really not following this sample data well. Click GO ADVANCED and use the paperclip icon to post up your workbook. Point out in the book exactly where you want things to show differently, perhaps mockup your desired results on another sheet...
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Sorry,
This is my first time using this site.
Thanks
Max
Last edited by maxbbles; 08-20-2009 at 09:37 AM.
Like so. I left the lunch breaks in decimal format since that seems LESS confusing. NOTE: The original sheet was in decimal format, not military format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks