Home

Schedule Times to Sum the Hours Scheduled

%3CLINGO-SUB%20id%3D%22lingo-sub-561492%22%20slang%3D%22en-US%22%3ESchedule%20Times%20to%20Sum%20the%20Hours%20Scheduled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561492%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20schedule%20that%20calculates%26nbsp%3B%20the%20%23%20of%20hours%20for%20each%20day%20and%20totals%20the%20hours%20in%20a%20column.%26nbsp%3B%20Hope%20you%20can%20see%20the%20attached%20link.%3C%2FP%3E%3CP%3EI'm%20trying%20to%20get%20the%20total%20hours%20minus%201%2F2%20hour%20each%20day%20worked%20to%20get%20the%20sum%20in%20column%20P%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-561492%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561499%22%20slang%3D%22en-US%22%3ERe%3A%20Schedule%20Times%20to%20Sum%20the%20Hours%20Scheduled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F109315%22%20target%3D%22_blank%22%3E%40Robert%20Hart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20great%20thing%20and%20experience%20for%20me.%3C%2FP%3E%3CP%3Eif%20you%20need%20free%20vpn%20you%20can%20download%20here%20%3CA%20href%3D%22http%3A%2F%2Fwww.gameof3halves.com%2Fexpress-vpn-crack%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eexpress%20vpn%20crack%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561531%22%20slang%3D%22en-US%22%3ERe%3A%20Schedule%20Times%20to%20Sum%20the%20Hours%20Scheduled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561531%22%20slang%3D%22en-US%22%3EI%20see%20no%20link.%20I%20prefer%20you%20attach%20your%20sample%20file%20with%20given%20data%20and%20desired%20results.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561544%22%20slang%3D%22en-US%22%3ERe%3A%20Schedule%20Times%20to%20Sum%20the%20Hours%20Scheduled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561544%22%20slang%3D%22en-US%22%3EI%20think%20I've%20got%20what%20I%20need%20except%20now%20I%20need%20to%20convert%20hours%20and%20minutes%20to%20a%20decimal%3A%3CBR%20%2F%3EExample%3A%209%20hours%2030%20minutes%20to%209.5.%20or%209%20hours%2015%20minutes%20to%209.25%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-561577%22%20slang%3D%22en-US%22%3ERe%3A%20Schedule%20Times%20to%20Sum%20the%20Hours%20Scheduled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561577%22%20slang%3D%22en-US%22%3EMultiply%20the%20time%20by%2024%2C%20then%20format%20the%20result%20as%20General%20or%20Number.%3C%2FLINGO-BODY%3E
Robert Hart
New Contributor

I'm trying to create a schedule that calculates  the # of hours for each day and totals the hours in a column.  Hope you can see the attached link.

I'm trying to get the total hours minus 1/2 hour each day worked to get the sum in column P

 

 

3 Replies
I see no link. I prefer you attach your sample file with given data and desired results.
I think I've got what I need except now I need to convert hours and minutes to a decimal:
Example: 9 hours 30 minutes to 9.5. or 9 hours 15 minutes to 9.25
Multiply the time by 24, then format the result as General or Number.