| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change times to 24 hour and add 6 hours in strings
Hi Is there a handy way of doing the above to strings in cells like this? Su Open 3:00p M-FR 5:00p-4:00p Much appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change times to 24 hour and add 6 hours in strings
What is it that you want to do exactly?
Pete On Apr 11, 4:54*pm, rkd wrote: Hi Is there a handy way of doing the above to strings in cells like this? Su Open 3:00p M-FR 5:00p-4:00p Much appreciated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change times to 24 hour and add 6 hours in strings
Take strings with times in them and update them to 24hour format and add 6 hours to change from CST to GMT. Example strings: Su Open 3:00p M-FR 5:00p-4:00p = Su Open 21:00 M-FR 23:00-22:00 M-FR 11:00a-4:00p = M-FR 17:00-22:00 Pete_UK wrote: What is it that you want to do exactly? Pete On Apr 11, 4:54�pm, rkd wrote: Hi Is there a handy way of doing the above to strings in cells like this? Su Open 3:00p M-FR 5:00p-4:00p Much appreciated! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change times to 24 hour and add 6 hours in strings
If you only have a few varieties of string, then perhaps Edit |
Replace (CTRL-H) a few times might be appropriate: Find what: 5:00p-4:00p Replace with: 23:00-22:00 Replace All CTRL-H again: Find what: 11:00a-4:00p Replace with: 17:00-22:00 Replace All CTRL-H again: Find what: 3:00p Replace with: 21:00 Replace All and so on. Hope this helps. Pete On Apr 12, 12:07Â*pm, rkd wrote: Take strings with times in them and update them to 24hour format and add 6 hours to change from CST to GMT. Example strings: Su Open 3:00p M-FR 5:00p-4:00p Â* Â* Â* Â* Â*= Su Open 21:00 M-FR 23:00-22:00 M-FR 11:00a-4:00p Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* = M-FR 17:00-22:00 Pete_UK wrote: What is it that you want to do exactly? Pete On Apr 11, 4:54�pm, rkd wrote: Hi Is there a handy way of doing the above to strings in cells like this? Su Open 3:00p M-FR 5:00p-4:00p Much appreciated!- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a formula to muliply hours times dollars per hour? | Excel Discussion (Misc queries) | |||
| Excel should be able to format 12-hour times without am/pm | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| How do I sum times to get a total hour value? If I add up to 24 h. | Excel Discussion (Misc queries) | |||
| subtracting times using 24 hour clock | Excel Worksheet Functions | |||
Linear Mode
