Hi,

We have MS Office 2003, Windows XP, in a network environment.

I have a worksheet that calculates time elapsed. Currently, the result is
displayed as hours and minutes. I would like it displayed as a decimal value
instead.

For example, here are my columns --

Date/Time Started
1/5/09 4:50 PM

Date/Time Ended
1/5/09 6:05 PM

Time Elapsed:
1:15

Formula for Time Elapsed column:
=TEXT(C30-B30,"h:mm")

As you can see, time elapsed is displayed as 1 hour 15 minutes. Instead, I
would like it displayed as a decimal value: 1.25

How can I adjust my formula to do this?

Note: Time elapsed will never exceed 12 hours. Our workday starts at 8am
and ends at 9pm (2 shifts), so all results would be within one 24-hour period.

Many thanks,
Rosemary