Hi Bruce,
Thanks for your effort to help me.
And yes, you're on the right track!
FYI: In Sweden we also write 10:45 if we actually want to say 45 minutes past 10.
But, as I think that writing 10:45 is slower than writing 10,45 I hoped someone could help me on to the right trackand still get the right sum.
Now I need to convert this so it works in my environment.
Thanks Bruce!
//Thomas
Thomas: check out this thread for some VBA code to simplify time entry:
http://www.excelforum.com/showthread.php?t=354367
then substitute this code in the appropriate spot for that posted on the above thread: (this code is for HH:MM:SS the posted code is for MM:SS only)
If .HasFormula = False Then
Select Case Len(.Value)
Case 1 ' e.g., 1 = 00:01 AM
TimeStr = "00:0" & .Value
Case 2 ' e.g., 12 = 00:12 AM
TimeStr = "00:" & .Value
Case 3 ' e.g., 735 = 7:35 AM
TimeStr = Left(.Value, 1) & ":" & _
Right(.Value, 2)
Case 4 ' e.g., 1234 = 12:34
TimeStr = Left(.Value, 2) & ":" & _
Right(.Value, 2)
Case 5 ' e.g., 12345 = 1:23:45 NOT 12:03:45
TimeStr = Left(.Value, 1) & ":" & _
Mid(.Value, 2, 2) & ":" & Right(.Value, 2)
Case 6 ' e.g., 123456 = 12:34:56
TimeStr = Left(.Value, 2) & ":" & _
Mid(.Value, 3, 2) & ":" & Right(.Value, 2)
Case Else
Err.Raise 0
End Select
HTH
Bruce
Last edited by swatsp0p; 03-15-2005 at 05:27 PM.
Bruce
The older I get, the better I used to be.
USA
Hi Bruce,
I actually already use that code already.
I think that McPearson wrote it, but I'm not sure.........
The problem is that I have 3 cells, start, stop and lunchbreak. Then I have 6 hidden columns calculating diffent conditions from the start, stop and lunchbreak time.
Then I start of on a new day, and so on, for a hole week........
Therefore, it will be a lot of differrent ranges, some to be calculated as decimals, some to be calculated as HH:MM.
So, I have to think about how to do this.....
//Thomas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks