Convert time to decimal value by formatting?

I thought this would be an easy task - simply convert H:mm to a decimal value! I wasn't able to find a solution on any websites, ended up trying the HOUR function. Great as long as there aren't any minutes involved... I know there's got to be any easy way to do something as common as this must be, but it eludes me - can someone help me with this "simple" dilemma??

Thanks for any help on this! Aaaaaaarrrggh...

Originally Posted by Glenn Kennedy

Surely this is all you need??
=B4-B3, copy across and format cells as hh:mm

I need decimal values, i.e., 3:45 is 3.75 hrs

Originally Posted by AliGW

Try this:

=HOUR(SUM(E4-E3))+(MINUTE(SUM(E4-E3))/100)

8 hours and 15 minutes comes out as 8.15 instead of 8.25

Originally Posted by Glenn Kennedy

I can't read, it seems!!

=(B4-B3)*24 formatted as general.

I tried that - comes out as 8, not 8.25

Time is represented with decimal (days) values (1.00=24hours), so time value (in decimal hours) =TIME*24.
=(B4-B3)*24 it`s OK, check your cells formated settings.

Yes, it DOES work - thank you guys so much! One more question - if I change B3 and B4 to 6pm and 1am, how do you make it come out as +7 instead of -17 hours?

Try

=IFERROR((MOD(B4-B3,1))*24,"")

you must enter time as date and you can format cells to show just hour and minutes
B3=07.08.2016 18:00:00, B4=08.08.2016 01:00:00
Time is number between 0 (represents time 0:00 AM) and 0,999988425925926 (which represents time 23:59:59), 1.00 represent h 0:00 AM next day). B3 represent time of a day and B4 is time of another day.

you must enter time as date and you can format cells to show just hour and minutes
e.g. B3=07.08.2016 18:00:00, B4=08.08.2016 01:00:00
Time is number between 0 (represents time 0:00 AM) and 0,999988425925926 (which represents time 23:59:59), 1.00 represent h 0:00 AM next day). B3 represent time of a day and B4 is time of another day, so put those days in the cells if you want to be counted.

for moderators
please delete msg #13 and this, I can not make it