| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time in Excel
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in Excel
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. "Gibbyky2" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in Excel
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 "pdberger" wrote: 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. "Gibbyky2" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in Excel
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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Gibbyky2" wrote in message ... 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 "pdberger" wrote: 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. "Gibbyky2" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in Excel
i only require mm:ss unless total is over 59 mins
"Bernard Liengme" wrote: 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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Gibbyky2" wrote in message ... 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 "pdberger" wrote: 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. "Gibbyky2" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in Excel
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 "Gibbyky2" wrote in message ... i only require mm:ss unless total is over 59 mins "Bernard Liengme" wrote: 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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Gibbyky2" wrote in message ... 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 "pdberger" wrote: 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. "Gibbyky2" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in Excel
thanks for that
"David Biddulph" wrote: 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 "Gibbyky2" wrote in message ... i only require mm:ss unless total is over 59 mins "Bernard Liengme" wrote: 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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Gibbyky2" wrote in message ... 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 "pdberger" wrote: 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. "Gibbyky2" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time in Excel
I get 0:06:04 since you are adding 17 seconds to 47 seconds?
"Gibbyky2" wrote in message ... thanks for that "David Biddulph" wrote: 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 "Gibbyky2" wrote in message ... i only require mm:ss unless total is over 59 mins "Bernard Liengme" wrote: 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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Gibbyky2" wrote in message ... 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 "pdberger" wrote: 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. "Gibbyky2" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| How do i convert unix time to Julian time in excel? | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
| How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Linear Mode
