Home

Convert hour format to decimal format

%3CLINGO-SUB%20id%3D%22lingo-sub-864042%22%20slang%3D%22en-US%22%3EConvert%20hour%20format%20to%20decimal%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-864042%22%20slang%3D%22en-US%22%3EI%20want%20to%20convert%203%3A30%20to%203.5%2C%20what%20is%20the%20best%20and%20easy%20way%20to%20do%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-864042%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-864108%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20hour%20format%20to%20decimal%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-864108%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412099%22%20target%3D%22_blank%22%3E%40Everq%3C%2FA%3E%26nbsp%3B%2C%20that's%20not%20only%20formatting%2C%20you%20shall%20multiply%20this%20value%20on%2024%20and%20apply%20number%20format.%3C%2FP%3E%0A%3CP%3EIn%20Excel%20time%20is%20actually%20decimal%20part%20of%20the%20number%20where%201%20hour%20%3D%201%2F24.%20Days%20are%20integer%20part.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-869488%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20hour%20format%20to%20decimal%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869488%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E
Everq
New Contributor
I want to convert 3:30 to 3.5, what is the best and easy way to do it?
2 Replies

@Everq , that's not only formatting, you shall multiply this value on 24 and apply number format.

In Excel time is actually decimal part of the number where 1 hour = 1/24. Days are integer part.

Thank you!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies