I want to enter a departure time and an arrival time in hours and minutes then have it calculate the elapsed time in hours and tenths.

I can get it to calculate elapsed time in hours and minutes but am having a problem converting it to hours and tenths.

Thank you in advance!

I can get it to calculate elapsed time in hours and minutes but am having a problem converting it to hours and tenths.

Thank you in advance!

- Converting hours and minutes to minutes
- How do I change my text direction to vertical on EXcell?
- How do I sum hours and minutes totalling over 24 hours?
- How do I add hours and minutes eg 4.50 + 2.30 = 7.20
- How do I change "Windows User" in Comments box to my own name?
- How do I change numeric column designations to alpha?
- How do I change a Browse Box to a constant folder?
- How do I change excell doc to all caps?
- How do I change language in excel?
- HOW DO I CHANGE ABSENCE TEMPLATE 2005, TO 2006
- How do I change a thread message format to html?
- Why Excel do not change hours and minutes to minutes correct
- How do I sum hours in Excel and convert to decimal numbers?
- How can I add hours and minutes then multiply by cost per hour?
- How do I modify the PMT formula to change between monthly and annual compounding?
- How do I change the format of cells
- Column headers changed from letters to numbers, how do I change ba
- How do i change (or add) colour to the worksheet tabs (in excel)
- How do I activate the xls feature to combine and compare workbooks
- How do I change personal info to track changes to shared workbooks
- Moved database, how do I change link to the database in excel
- How do I change z-axis value from zero to a higher number (eg 4)?
- How do I change a macro to use relative cell addresses?
- How do I change the column heading in Excel to display "A" "B" "C

excel to give actual total times where the total exceeds 24 hours?

User". How do I change this (as opposed to just editing it every time)?

alpha on the columns and numeric on the rows. Can I set that in preferences?

If now, how do I change it when it happens (seemingly at random)?

For example, C:Batch

I have tried this but it didn't work out:

FileList = Application.GetOpenFilename _

(FileFilter:="C:Batch(*.*), *.*", _

Title:="Select files", MultiSelect:=True)

I am using this macro to open a group of text files in one worksheet.

Thank you,

Adam

Sub InsertDataFromTextFiles()

Dim ColumnOffset As Long

Dim DestCell As Range

Dim i As Long

Dim SourceData As Range

Dim FileList As Variant

Sheets("Sheet1").Select

Const ColumnsPerFile As Long = 13

FileList = Application.GetOpenFilename _

(FileFilter:="All Files(*.*), *.*", _

Title:="Select files", MultiSelect:=True)

'returns an array if at least 1 file is selected

'if user cancelled, returns Boolean = False

If TypeName(FileList) <> "Variant()" Then Exit Sub

Application.ScreenUpdating = False

Application.DisplayAlerts = False

Set DestCell = Selection.Range("A1")

ColumnOffset = -ColumnsPerFile 'will increment to 0 on 1st pass

For i = LBound(FileList) To UBound(FileList)

Set SourceData = _

Workbooks.Open(FileName:=FileList(i)).Worksheets(1 ).UsedRange

Selection.CurrentRegion.Select

Selection.Copy

ColumnOffset = ColumnOffset + ColumnsPerFile

DestCell.Offset(0, ColumnOffset).PasteSpecial Paste:=xlFormulas

Application.CutCopyMode = False

SourceData.Parent.Parent.Close SAVECHANGES:=False

Next i

DestCell.Activate

Application.DisplayAlerts = True

Application.ScreenUpdating = True

End Sub 'InsertDataFromTextFiles

How do I change it from hebrew to english, or even better, french?

Thanks for your help,

Meirav.

great, how do i change or get to perform the 2006 yesr

In A1 timevalue 1200:00 (= 1200 hours and 00 minutes.

In B1 I have formula: =HOUR(A1)*60+MINUTE(A1)

Answer is 0. Should not be.

When changing A1 to 1200:30, I get answer 30 (that is 30 minutes).

Where I am doing wrong? Is there any problem with formula?

Best Regards Sir Vili.

how to have the results calculate the product. But how do I some a column of

hours? Or how do I change the products into decimal numbers? e.g. 1:00

should equal 1.0

projects within those places. I need to let the real estate firm know what I

did and how long it took to do it. I need to put together a time sheet

showing what time I started a project and what time I ended that project. A

column with the total number of hours and minutes after that. A total number

of hours and minutes at the bottom of that column. And a total cost for the

hours worked. I need a column with description of what I did and then at the

very bottom a total for the entire job. Does anyone have any idea how I can

do this? I've tried and failed miserably, and I thought I was pretty

advanced in the use of Excel! So now I ask, rather, beg for help. Anyone????

PV $450,000

Rate: 6%

Term: 3 years

The payments will be monthly, but I want to show annual and monthly compounding. How do I change the formula? =pmt(.06/12,3*12,450000) This gets me monthly, what gets me annual?

Both rows and columns are numbers. I don't know how this happen. How do I

change it back so that column references are letters?

worksheet tabs in Excel? I'm working with a whack of tabs and would like to

give each one a different colour - but I can't for the life of me remember

how to do it.

Thanks!

AL

to combine workbooks and be able to compare the data in each; and show

changes between the books.

the image set "information services" as the name in the personal information,

so when a new user runs Office it uses that.

How do I change this to track who is changing or viewing workbooks?

data imports.

I can change the query easily but I can't find an option to repoint the

query to the databases new location. How do I change the location of the

database excel is querying?

Am using a floating bac chart presenting open hours for help desk support.

macro to run from a specific cell and relative to that cell?

column heading as "1" "2" "3" etc. How do I change it to A, B, C etc?