Entering And Adding Times Together

  • Thread starter Thread starter TomBrooklyn
  • Start date Start date
T

TomBrooklyn

1. Is there a way to enter a length of time in minutes and seconds?


(I found a way that requires hours to be entered along with minutes an
seconds, but that would require an extra "0:" keystrokes on ever
entry. )

2. How can I add these times together and display the result in hour
and minutes?

Note: time of day is irrelevant to this application.

Thanks,
TomBrookly
 
1. One way:

0:mm:ss

another:

mm:ss.0


2. Sum them as any other number (times in XL are stored as fractional
days - i.e., 3:00 = 0.125). Format your result with
Format/Cells/Number/Custom... [mm]:ss
 
Hi Tom

Right click on the sheet name tab, slect "View Code" and paste in this.


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
If IsNumeric(Target) Then
Application.EnableEvents = False
Target = Target / 60
Target.NumberFormat = "h:mm:ss"
Application.EnableEvents = True
End If
End If
End Sub

It, 'as is', will only effect column "A" and you can enter times now as
5:45 and it will be coneverted to 0:05:45



***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top