Excel hours minutes and seconds

  User-312386 00:06 11 Apr 07
Locked

Hi guys

Probably one for VOG here

I want just a simple thing done in excel

I want to be able to add minutes hours and seconds into excel.

I am useless at adding minutes and hours so i thought i would ask you guys.

Thanks in advance

  daba 00:31 11 Apr 07

OK, make sure your cells are formatted as "Custom", and in the format Type put the code [hh]:mm:ss

The square barckets allows for times greater than 24 hours (which is what you can get if you sum them)

  silverous 09:27 11 Apr 07

When you say "add"..."into"... excel.

Do you mean you want to add two durations together for example?

e.g. on a timesheet 1 hour 10 minutes 50 seconds
plus 2 hours 15 minutes 12 seconds?

Or just enter times as per daba's advice?

It isn't clear what you are trying to do from your post.

  Simsy 09:37 11 Apr 07

You must enter the colon, : between the sections. This tells Excel it's time you're dealing with. It's no good using a full stop, or comma, to seperate the sections.

You must use the square brackets as per daba's post, in the formatting for the cell where the total is... this tells Excel that the hours part you're referring to is a duration, not a time; For example, there is such a thing as a duration off 11 hours, and the "equivalent" time of 11 0'clock,... there is such a duration of 26 hours, but the "equivalent" time is 2 o'clock, not 26 o'clock

Hope this helps,

Regards,

Simsy

  daba 10:18 11 Apr 07

Couldn't have put it better myself....

  User-312386 14:25 11 Apr 07

Guys

I want to add two (sometimes three) lots of hours minutes and seconds together.

I am not really used to using excel, so please be gentle with me

  VoG II 14:29 11 Apr 07

If these are times entered as hh:mm:ss then it is straightforward e.g. with times in A1 and B1 then in C1 enter

=A1+B1

and format the cell as daba suggested.

  User-312386 20:48 19 Apr 07

Thanks guys

Done it as suggested

Sorry it took so long getting back to you

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…