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
Highlighted
Multiply the time by 24, then format the result as General or Number.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies