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
Highlighted
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
19 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies