Converting Time to decimal

[errol.francke]

How do I write a formula to calculate the following: start time 08h30 and end time 16h30 to give me an answer of 8 hours?

 

[rdw72777]

What format is your data in? Does it look exactly as you wrote it (i.e. typed in as text) or is it just a format that makes it look that way?

So long as its a format, youy could do:

=HOUR(A1-A2)&" hours"

Assumes your finish time is in A1 and your start time is in A2.

 

[VoG]

Try this - C1 is formatted as Number

Excel Workbook
	A	B	C
1	08:30	16:30	8.00
Sheet2

 

[rdw72777]

I see, after looking at Vog's help, that I oversimplified my solution (which won't work as it will round every time down). ignore my solution.

 

[errol.francke]

Works!

Thanks. I really do appreciate it!