Posted to microsoft.public.excel.misc

Jack Black Jack Black is offline

external usenet poster

Posts: 7

Time Trouble

I would like to put a date and time in A1 and a later date and time in
A2 and have B2 to show the difference between these 2 times in hours
to 2 digits .

Does anyone know how this can be done?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate Ending time using Start Time and Elapsed Time	Chief 711	Excel Worksheet Functions	5	May 13th 08 04:34 PM
Time trouble	excelent	Excel Worksheet Functions	3	February 21st 07 10:12 PM
Military time trouble	darkbearpooh1	Excel Worksheet Functions	7	February 19th 06 10:58 AM
time trouble	darkbearpooh1	Excel Worksheet Functions	1	February 9th 06 09:22 AM
Time Sheet for my org Im still having trouble	Jesse_Norris	Excel Discussion (Misc queries)	4	July 30th 05 06:28 AM

All times are GMT +1. The time now is 10:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us