| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time calculation assistance need...., maybe....
Hi all...,
I have a range of various times arranged in a single column..., <D2 = 8:29:46 AM, <D3 = 9:57:59 AM, <D4 = 1:38:40 PM..., etc. Using a formula or function in the column to the right, I want capture and display just the hour of these times..., <E2 = 8:00 AM, <E3 = 9:00am, <E4 = 1:00 PM. thanks - D |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stupid question -- time calculation | Excel Discussion (Misc queries) | |||
| Text Time Conversion Calculation | Excel Worksheet Functions | |||
| perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
| How do I calculation time in excel in 24 hour method | Excel Discussion (Misc queries) | |||
| "Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
Threaded Mode
