perhol
12-06-2007, 08:44 AM
I have made a working hours schedual for my work.
I want the statusbar on some of the sheets to show 3 values collected from another sheet in same workbook.
The code collect the wanted values and show them in the statusbar, but in a wrong format.
The values is in the format [H]:mm, but is showing in standard format (ie. 148:00 becomes 6,16666666666667 in the statusbar).
How can i make the values appear in the right format?
This is the code for the statusbar:
Application.StatusBar = navn & " - TimeNorm = " & TN & " - Rulleplan = " & RP & " - Vagtplantimer = " & VP
TN - RP - VP is variables containing the time i want to show in [H]:mm-format.
I want the statusbar on some of the sheets to show 3 values collected from another sheet in same workbook.
The code collect the wanted values and show them in the statusbar, but in a wrong format.
The values is in the format [H]:mm, but is showing in standard format (ie. 148:00 becomes 6,16666666666667 in the statusbar).
How can i make the values appear in the right format?
This is the code for the statusbar:
Application.StatusBar = navn & " - TimeNorm = " & TN & " - Rulleplan = " & RP & " - Vagtplantimer = " & VP
TN - RP - VP is variables containing the time i want to show in [H]:mm-format.