| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert time cell
Cell D35 on sheet1 is formatted as time ([hh:mm]). It can
contain anything from 00:00 to 123:45 What I want to do is round the time to the nearest half an hour and then convert it to text. For example, if D35 had 10:15 (0.427083) in it then I want B6 on sheet2 to be 10:30 Any help gratefully received. Gareth |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert time cell
Hi
see: http://www.xldynamic.com/source/xld.Rounding.html#time -- Regards Frank Kabel Frankfurt, Germany "Gareth" schrieb im Newsbeitrag ... Cell D35 on sheet1 is formatted as time ([hh:mm]). It can contain anything from 00:00 to 123:45 What I want to do is round the time to the nearest half an hour and then convert it to text. For example, if D35 had 10:15 (0.427083) in it then I want B6 on sheet2 to be 10:30 Any help gratefully received. Gareth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert time stored as decimalised number to time format | New Users to Excel | |||
| Convert time in cell | Excel Discussion (Misc queries) | |||
| Can I convert numeric 0510 to time 05:10 by custom cell format? | Excel Discussion (Misc queries) | |||
| In Excel how can you convert a cell formatted for time (4:30) to . | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Hybrid Mode
