Home

How to change hours worked on a project from 24 hr time to a decimal hr?

%3CLINGO-SUB%20id%3D%22lingo-sub-304272%22%20slang%3D%22en-US%22%3EHow%20to%20change%20hours%20worked%20on%20a%20project%20from%2024%20hr%20time%20to%20a%20decimal%20hr%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304272%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20what%20I%20have%3A%20Cell%20O5%20is%20clock%20in%20time%2C%20cell%20P5%20is%20clock%20out%20time.%20They%20are%20both%20formatted%20military%20time%2C%20cell%20Q5%20is%20total%20hours%20with%20simple%20formula%20%3DP5-O5%26nbsp%3B%20I%20want%20this%20to%20not%20be%20in%20time%20format%20though.%3C%2FP%3E%3CP%3EExample%20O5%20is%2010%3A30%2C%20P5%20is%2017%3A00%2C%20Q5%20is%206%3A30%2C%20I%20want%20Q5%20to%20read%20as%206.5%20hrs%20so%20I%20can%20keep%20total%20of%20hours%20for%20the%20job%20at%20the%20end%20of%20these%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304272%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304420%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20hours%20worked%20on%20a%20project%20from%2024%20hr%20time%20to%20a%20decimal%20hr%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304420%22%20slang%3D%22en-US%22%3E%3CP%3EInstead%20of%20your%20formula%20you%20may%20use%3C%2FP%3E%0A%3CPRE%3E%3D(P5-O5)*24%3C%2FPRE%3E%0A%3CP%3Eand%20apply%20General%20or%20Number%20format%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

This is what I have: Cell O5 is clock in time, cell P5 is clock out time. They are both formatted military time, cell Q5 is total hours with simple formula =P5-O5  I want this to not be in time format though.

Example O5 is 10:30, P5 is 17:00, Q5 is 6:30, I want Q5 to read as 6.5 hrs so I can keep total of hours for the job at the end of these columns.

1 Reply
Highlighted

Instead of your formula you may use

=(P5-O5)*24

and apply General or Number format 

 

Related Conversations
Talk with Project Engineers!
jackieduong in Project on
0 Replies
Time and Yes/No
Rob Nunley in SharePoint on
0 Replies
WVD On/Off based on activity
Adam Black in Windows Virtual Desktop on
2 Replies
MS Project - Impression GANTT + Ressources
Emmanuel57570 in Project on
1 Replies