| Home |
| Search |
| Today's Posts |
|
#20
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Standard Time for H:MM Formula
Yes, You did a wonderful job in helping me. :)
"Tom Ogilvy" wrote: Just for completeness: And I replied. You responded that what I sent appeared satisfactory. -- Regards, Tom Ogilvy "Benz" wrote: I sent you an e-mail from benzNbent@hotmail "Tom Ogilvy" wrote: Send me a sample worksheet to (with a valid return address) or give me your email and I will send you something with all of them working. -- Regards, Tom Ogilvy "Benz" wrote: Am I doing something wrong? I've tried everything everyone of you have so nicely suggested and nothing has worked. "Benz" wrote: To compute time spent on hourly projects, I need to know formula that will allow me to enter standard time and have it find the difference ie/ (Start)A1: 4:00 (End)A2: 6:48 (Total)A3: 2.8 It sounds so easy just subtract the time and divide the Minutes by 60 but I just cant get it. Plz help! Thank You. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| Converting standard time to military time | Excel Worksheet Functions | |||
| how can we enter at the same time maintain a formula in a cell? | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| How do I enter a time formula into a worksheet that determines if. | Excel Discussion (Misc queries) | |||
Threaded Mode
