Converting time from 3:30 to 3.50

If you have the time in hours:minutes in column A,
then column B could have formulas in this format:

[B1] = HOUR(A1)+ MINUTE(A1)/60

This converts to decimalized hours. But do
take care not to try to add columns A and B
together: 3:30 is the same to Excel as 0.15,
not 3.50.

Thank you!! That works fine except when I go over 24 hours.
Do you have any suggestions for going up to 200 hours??

you could try
=( HOUR(F15)+INT((F15))*24)+ MINUTE(F15)/60

Ivan

1. Converting time from 3:30 to 3.5:
[time_cell]*24 will give you 3.5 in decimal format.

2. If you want to show hours>=24:00, then use Format-Cells-Custom, and put [hh]:mm and it will show you any hours >= 24.

Hope it helps.