Summing Time (Hh:MM)

[muhammad susanto]

hi all..

how to sum time this below:

Book1
	E	F	G
2	time	add time (minutes)	my target
3	7:30	30	8:00
4	7:40	45	8:25
Sheet1

my target in cell G3 down.
any help, thank in advance

.sst

 

[mohadin]

7:30+00:30=8:00

 

[muhammad susanto]

not like this my format in time (hh:mm)

 

[mohadin]

G3=E3+F3

 

[maabadi]

Because of time calcuated as part of Day And 1 hour equal is 1/24 and 1 minute equal 1/1440
Then Use this formula:

=E3+F3/1440

and if your hours is more than 24 hour change number format to Custom and at types part write: [h]:mm