# calculating time with spreadsheet

## Recommended Posts

Hi

I need to use excel or any type of spreadsheet to calculate my work hours.

In other words I need to calculate how many hours did I work.

Anyway I used excel in one square I write the time that I begin, like for example 5:30, in other square I write the time I finished to work like 14:00.

Now what function can I used that it will calculate that time that I worked in hour unit.

So that in the case of the example it will give me 8.5 hours.

Thanks for the help.

##### Share on other sites

Only way I could see this work is if you convert the times to decimal so the 8:30 would become 8.5, then you can just use the normal math functions built into excel for it, but that won't work well if you get off at strange times like 8:27.

##### Share on other sites

That is why I ask whether there is a function in spreadsheet that can calculate this without me changing 8:30 to 8.5

##### Share on other sites

I'm guessing here, but if you set the cell format to time will it not just allow you to subtract one from the other?

##### Share on other sites

You definitely can in Open Office, I'd assume you can do the same in Excel - just right click on a cell/bunch of cells and select format.

##### Share on other sites
That is why I ask whether there is a function in spreadsheet that can calculate this without me changing 8:30 to 8.5

You might be looking for something like this?

=HOUR(B1-A1) + MINUTE(B1-A1)/60

Where A1 is the beginning time, B1 is the end time.

A1, B1 would be formatted as simple time, the result cell would be formatted as general

##### Share on other sites

If Excel doesn't understand time-formatted math, just put the hours and minutes in different cells.

##### Share on other sites

openoffice calc can do this if the cells containing the times are formatted as containing a time.

i imagine excel should do this too, if it can't then it isn't really much of a spreadsheet program as they are commonly used to contain and calculate time based data. try looking in the help.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account