Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Greg T
 
Posts: n/a
Default how to convert total hours (HH:MM) into decimal number

How can I convert total time (HH:MM) into a decimal (HH.MM)
Where 30 minutes (xx:30) equals .50.
So far I have the formula
=(INT(VALUE(O16))*24)+(HOUR(VALUE(O16)))+((MINUTE( VALUE(O16))/100))
but still need to convert minutes to decimal
  #2   Report Post  
Paul Corrado
 
Posts: n/a
Default

With time in A1 (10:30 for example)

=A1*24 will yield 10.5

Note that time is already in decimal format in XL. The format option
displays the time as hours, minutes and seconds.



"Greg T" <Greg wrote in message
...
How can I convert total time (HH:MM) into a decimal (HH.MM)
Where 30 minutes (xx:30) equals .50.
So far I have the formula
=(INT(VALUE(O16))*24)+(HOUR(VALUE(O16)))+((MINUTE( VALUE(O16))/100))
but still need to convert minutes to decimal



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 11:24 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
Problems calculating total hours LolaK Excel Discussion (Misc queries) 1 December 14th 04 05:23 PM
Convert week number into calendar month? WickyWick Excel Worksheet Functions 2 November 9th 04 10:01 PM
Rounding a number to a multiple quantity that adds to a fixed total number wjlo Excel Worksheet Functions 1 November 9th 04 05:43 PM


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"