I am using MS Office 2003. I am subtracting two times(hh:mm) and getting a
time value which I want to convert to number.

For example:
If the final value is 08:00 then I want to change it to 8 or if the value if
07:30 then it should be changed to 7.5

I tried using Integer function but it gives 00:00 or #######

Any idea guys??

i think if you format cell to number format that iwll work you can then
format back to time again

"Plan Ahead" wrote:

I am using MS Office 2003. I am subtracting two times(hh:mm) and getting a
time value which I want to convert to number.

For example:
If the final value is 08:00 then I want to change it to 8 or if the value if
07:30 then it should be changed to 7.5

I tried using Integer function but it gives 00:00 or #######

Any idea guys??

Multiply by 24 and format the result as a number. (24 because '1' in Excel
is a day, so an hour is 1/24. That's also why the int function is giving you
0).

"Plan Ahead" wrote:

I am using MS Office 2003. I am subtracting two times(hh:mm) and getting a
time value which I want to convert to number.

For example:
If the final value is 08:00 then I want to change it to 8 or if the value if
07:30 then it should be changed to 7.5

I tried using Integer function but it gives 00:00 or #######

Any idea guys??

Multiply by 24 and format as General (or Number)

Plan Ahead wrote:

I am using MS Office 2003. I am subtracting two times(hh:mm) and getting a
time value which I want to convert to number.

For example:
If the final value is 08:00 then I want to change it to 8 or if the value if
07:30 then it should be changed to 7.5

I tried using Integer function but it gives 00:00 or #######

Any idea guys??

--

Dave Peterson