Two time variables in a single cell

[Luke777]

Hi all,

I have two variables called StartTime and EndTime. Each can be displayed as a time in a given cell.

I would like to combine both variables to create a new variable called StartEndTime which can then be displayed in a given cell with the time format of "6:30-15:00"

So far my efforts have lead to the decimals of these numbers being displayed.. halfway there lol

Any ideas?

Thanks in advance!

 

[offthelip]

Assuming start time is in A2 and end time in b2:

=TEXT(A2,"hh:mm") & " - " & TEXT(B2,"hh.mm")

 

[Luke777]

Assuming start time is in A2 and end time in b2:

=TEXT(A2,"hh:mm") & " - " & TEXT(B2,"hh.mm")

Sorry, I should’ve been clearer, I’m doing this with VBA

 

[offthelip]

try this:

Sub test()
St = Cells(2, 1)
et = Cells(2, 2)
 sthr = Hour(St)
 stmn = Minute(St)
 ethr = Hour(et)
 etmn = Minute(et)
 MsgBox (sthr & ":" & stmn) & "-" & (ethr & ":" & etmn)
 
  
End Sub

 

[Luke777]

try this:

Sub test()
St = Cells(2, 1)
et = Cells(2, 2)
 sthr = Hour(St)
 stmn = Minute(St)
 ethr = Hour(et)
 etmn = Minute(et)
 MsgBox (sthr & ":" & stmn) & "-" & (ethr & ":" & etmn)
 
 
End Sub

This seems to work 99% fine - the only issue I'm having is "06:30:00 and 15:00:00" (test time) are joining together as "6:30-15:0". Annoyingly lacking a zero lol

 

[mohadin]

May be

Sub test()
    StartTime = Cells(2, 1)
    EndTime = Cells(2, 2)
    StartEndTime = Format(StartTime, "h:mm") & "-" & Format(EndTime, "h:mm")
    MsgBox StartEndTime
  
End Sub

"h:mm" Or "h:mm:ss"