| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks Herald for an excellent link and the solution. The thing is there are
people who learn patiently and methodically and there are others like me who start fumbling when the need arizes. I am trying to get better. Thanks once again! "Harald Staff" wrote: "JE McGimpsey" skrev i melding ... In article , "Harald Staff" wrote: You have to know a little theory on this. 1 is a day in excel. Which makes 0.5 half a day, 12 hours, and 8:30 the same as 1/3. Starting the day at 00:30, Harald? <g Doh!!! 1/3 = 8:00 Sorry & thanks. Best wishes Harald |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
