Home

Line Graph Time Duration

%3CLINGO-SUB%20id%3D%22lingo-sub-815779%22%20slang%3D%22en-US%22%3ELine%20Graph%20Time%20Duration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815779%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20trying%20to%20chart%20minutes%3Aseconds%20week%20by%20week%20for%20a%20run%20of%2012%20weeks.%26nbsp%3B%20So%20wk1%2030min27secs%2C%20wk%202%2032min35secs%2C%20etc.%26nbsp%3B%20When%20I%20initially%20format%20the%20chart%20data%20as%20%5Bh%5D%3Amm%3Ass%20it%20works%20although%20the%20formula%20bar%20still%20shows%20a%20date(%3F)%20but%20when%20I%20copy%2011%20weeks%20and%20paste%20above%20line%2012%20and%20update%20line%2012%20with%20the%20latest%20week%2C%20it%20changes%20the%20format%20even%20though%20when%20i%20go%20to%20format%20that%20cell%2C%20it%20is%20the%20same%20as%20above.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816040%22%20slang%3D%22en-US%22%3ERe%3A%20Line%20Graph%20Time%20Duration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396195%22%20target%3D%22_blank%22%3E%40Randel2001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhere%20exactly%20format%20is%20changed%20and%20on%20what%3F%20In%20your%20file%20all%20looks%20correct%20except%20one%20cell%20which%20is%20entered%20as%20text%2C%20not%20time.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20366px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127898i885D3DC143350310%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Randel2001
Occasional Visitor

i am trying to chart minutes:seconds week by week for a run of 12 weeks.  So wk1 30min27secs, wk 2 32min35secs, etc.  When I initially format the chart data as [h]:mm:ss it works although the formula bar still shows a date(?) but when I copy 11 weeks and paste above line 12 and update line 12 with the latest week, it changes the format even though when i go to format that cell, it is the same as above. 

1 Reply

@Randel2001 

Where exactly format is changed and on what? In your file all looks correct except one cell which is entered as text, not time.

image.png

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies