Time in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gibbyky2 - 24 May 2008 16:06 GMT

I am working on a template for stats, when i enter time in mm:ss it shows and
calculates incorrectly. can anyone help in solving this problem

thanks

Reply to this Message

pdberger - 24 May 2008 16:32 GMT

You need to describe your problem in more detail. It may help to know that
Excel may display time as hh:mm:ss, but stores it as a decimal starting with
0.000 as 12 midnight, and 0.5 as noon. So Excel, in date/time formats, Excel
considers the number 1.5 to be Jan 1, 1900 12:00 PM. 2.25 would be Jan 2,
1900 6:00 AM. and so on.

Hope that points you in the right direction.

> I am working on a template for stats, when i enter time in mm:ss it shows and
> calculates incorrectly. can anyone help in solving this problem
>
> thanks

Reply to this Message

Gibbyky2 - 24 May 2008 16:58 GMT

what i am trying to do is the following

A1 is 5mins 17s B1 is 37sec C1 is A1 + B1
A2 is 6mins 10s B2 is 4mins 57s C2 is A2 + B2

A50 is C1 + C2 etc

> You need to describe your problem in more detail. It may help to know that
> Excel may display time as hh:mm:ss, but stores it as a decimal starting with
[quoted text clipped - 8 lines]
> >
> > thanks

Reply to this Message

Bernard Liengme - 24 May 2008 17:34 GMT

A1= 0:5:47
B1= 0:0:17
C1= A1+B1 and displays 0:5:54
What do you get that is wrong?
best wishes

Signature

Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

> what i am trying to do is the following
>
[quoted text clipped - 20 lines]
>> >
>> > thanks

Reply to this Message

Gibbyky2 - 24 May 2008 18:56 GMT

i only require mm:ss unless total is over 59 mins

> A1= 0:5:47
> B1= 0:0:17
[quoted text clipped - 25 lines]
> >> >
> >> > thanks

Reply to this Message

David Biddulph - 24 May 2008 20:28 GMT

You can display what you like (Format/ Cells), but in inputting the data you
need to let Excel know that you want 0:5:47 and not 5:47:00
Hence Bernard's reply to you.
--
David Biddulph

>i only require mm:ss unless total is over 59 mins
>
[quoted text clipped - 30 lines]
>> >> >
>> >> > thanks

Reply to this Message

Gibbyky2 - 24 May 2008 22:51 GMT

thanks for that

> You can display what you like (Format/ Cells), but in inputting the data you
> need to let Excel know that you want 0:5:47 and not 5:47:00
[quoted text clipped - 36 lines]
> >> >> >
> >> >> > thanks

Reply to this Message

Meebers - 25 May 2008 01:15 GMT

I get 0:06:04 since you are adding 17 seconds to 47 seconds?

> thanks for that
>
[quoted text clipped - 41 lines]
>> >> >> >
>> >> >> > thanks

Reply to this Message