hours and minutes

h58299 · May 18th, 2002, 09:33 AM

when i custom format to h.mm the total changes to 10:00 even though the total number of minutes is 625 which is 10 hours and 25mins

Dave Patton · May 18th, 2002, 09:42 AM

[quote]
On 2002-05-18 08:33, h58299 wrote:
when i custom format to h.mm the total changes to 10:00 even though the total number of minutes is 625 which is 10 hours and 25mins

Custom format to h:mm or if total may exceed 24 [h]:mm

h58299 · May 18th, 2002, 10:00 AM

i have formatted it to h:mm and [h]:mm and it still totals to 0:00, could it be because it is a total sum from a number of cells.

Dave Patton · May 18th, 2002, 10:05 AM

[quote]
On 2002-05-18 09:00, h58299 wrote:
i have formatted it to h:mm and [h]:mm and it still totals to 0:00, could it be because it is a total sum from a number of cells.

What formula are you using?
Are you entering the numbers as time?

19:00
12:00
5:30
36:30

36:30 is =SUM(B2:B4) format [h]:mm

h58299 · May 18th, 2002, 10:20 AM

what i have is a datasheet with all times on it and a input sheet that has blank cells by certain jobs that i do, and when i type in how many of a certain job i have done it gets the information of the other sheet and displays it in another cell and then another cell totals it all together, if you can see what i mean, i am a beginner in excel so i might have got it all wrong.

[ This Message was edited by: h58299 on 2002-05-18 09:57 ]

sykes · May 18th, 2002, 10:31 AM

Hi chaps
I've posted my answer on the other string that's going at the moment, but in short,
add up the minutes
divide by 1440
then CUSTOM format [h]:mm

let me know how you get on

Sykes

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 18th, 2002, 09:33 AM	#1
h58299 New Member Join Date: Apr 2002 Posts: 15	when i custom format to h.mm the total changes to 10:00 even though the total number of minutes is 625 which is 10 hours and 25mins

May 18th, 2002, 09:42 AM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	[quote] On 2002-05-18 08:33, h58299 wrote: when i custom format to h.mm the total changes to 10:00 even though the total number of minutes is 625 which is 10 hours and 25mins Custom format to h:mm or if total may exceed 24 [h]:mm

May 18th, 2002, 10:00 AM	#3
h58299 New Member Join Date: Apr 2002 Posts: 15	i have formatted it to h:mm and [h]:mm and it still totals to 0:00, could it be because it is a total sum from a number of cells.

May 18th, 2002, 10:05 AM	#4
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	[quote] On 2002-05-18 09:00, h58299 wrote: i have formatted it to h:mm and [h]:mm and it still totals to 0:00, could it be because it is a total sum from a number of cells. What formula are you using? Are you entering the numbers as time? 19:00 12:00 5:30 36:30 36:30 is =SUM(B2:B4) format [h]:mm

May 18th, 2002, 10:20 AM	#5
h58299 New Member Join Date: Apr 2002 Posts: 15	what i have is a datasheet with all times on it and a input sheet that has blank cells by certain jobs that i do, and when i type in how many of a certain job i have done it gets the information of the other sheet and displays it in another cell and then another cell totals it all together, if you can see what i mean, i am a beginner in excel so i might have got it all wrong. [ This Message was edited by: h58299 on 2002-05-18 09:57 ]

May 18th, 2002, 10:31 AM	#6
sykes Board Regular Join Date: May 2002 Location: Cornwall,England Posts: 1,273	Hi chaps I've posted my answer on the other string that's going at the moment, but in short, add up the minutes divide by 1440 then CUSTOM format [h]:mm let me know how you get on Sykes