Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format function doesn't recognise [hh]:mm
Hi,
Is there a way of getting the format function in VBA or anothe function that will do the same job to recognise the custom forma [hh]:mm? When reopening a user form, it fills in the values from the relevan line on the worksheet into the boxes. However as the time in the worksheet can be over 24 hours, e.g. 4 hours (by using the custom format [hh]:mm), I would like the box i the user form to show the value in hours and minutes too even if it i above 23:59:59. This does not work cboResponse1.Value = Format (ActiveCell.Offset(0, 8).Value, "[hh]:mm") This only works for values under 24:00 cboResponse1.Value = Format (ActiveCell.Offset(0, 8).Value, "hh:mm") cboResponse1.Value = ActiveCell.Offset(0, 8).Value and this return just displays the time in a numerical format e.g 1.45..... Thanks for any help you can give Jenni -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Sum function does recognise % | Excel Worksheet Functions | |||
conitif doesn't recognise time format? how to get round this? | Excel Worksheet Functions | |||
How to get an Excel function to recognise text | Excel Discussion (Misc queries) | |||
excel can no longer recognise format | Excel Discussion (Misc queries) | |||
Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? | Excel Discussion (Misc queries) |