"time" for a timesheet.

[Hawker1950]

I'm working on a time sheet to be used by co-workers and self. In column "F" the start time is keyed in by the user, and in column "G" the stop time is entered by the user. I would like to find a formula for column "H" that would display the time for each job & time entry. Column's "F" & "G" are in 24 hr format (13:30, etc) and column "H" would need to display the time for each job in hours & tenths such as: 13:30 - 14:42 = 1.2
I've been banging my head on this one so any help would be much appreciated! Thanks in advance for any help that can be provided.
Steve

[Paul]

Hi hawker,

You can simply use the formula:

=(G1-F1)*24

and format the cell as Number instead of Time.

[Special-K]

I wish I'd have read pjoaquin's reply half hour ago before I ended up with

=INT((G1-F1)/0.041666)+((G1-F1)-INT((G1-F1)/0.041666)*0.041666)/0.041666


:-)

[Paul]

No worries, Special-K.. we've all been there. I've written UDF's not realizing there's a perfectly simple worksheet function already available.

Fortunately there are many ways to do things in Excel. Unfortunately there are many ways to do things in Excel, too.

[Hawker1950]

pjoaquin (Paul)

Thank you for that formula help, it works great. I would have sworn I tried one very close to that, but evidently not! One quick question in regards to the formula though. When I enter a time in column "F" (17:30 for instance) and before I enter a time into column "G", column "H" which contains the formula will display -17:30 until a time is entered into column "G". Is there a way I can keep anything from being displayed in "H" till the end time is entered into "G"?

Thanks again so much for your help! Formulas are my weak link! Thanks to you too Special-K, I tried your formula also, but gotta say pjoaquin's was pretty much right on to what I'm needing! Not to worry, I'll end up having lots more questions in the future and requests for help!
Steve

[Paul]

To keep column H blank until G is filled in, use:

=IF(G1="","",(G1-F1)*24)