I need to be able to use time in an arithmetic formula. For instance, if a cell has a number representing 45 minutes, I need that calculated as .75(or 3/4ths of a minute)but I would like the visual formatting to be a date/time type(00:00:45). I know there must be a way, any help.

You will need to call the decimal value for your formula from another cell. i,e in cell A1 you have the time 00:45:00 (hh:mm:ss) to calculate the decimal value in cell A2 type =A1*24. You would then use the value in cell A2 in your formula. Hope this helps.

Hi there, Stevieb, i don't wanna seem arrogant, but that will only work when the format of cell A2 is set to a number. And when used like this it will copy the format from the A1 cell hh.mm.ss Another option is using the next formula in Cell A2 =A1/60 This will give you a decimal value of the minutes, but there are allot of different options here, using different command, just don't have enough info to determine what is best in this case With regards Mike