Formula for computing work time in Excel

A

Alex Vinokur

Hi,

For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.

What is the formula?

If I use formula B1 - A1 - 0:30 I get invalid value.

Thanks,
 
G

Guest

That's because time is really just a floating point number.

1 is 1 day
and hour is 1/24
a half hour is 1/48

=B1 - A1 - 1/48

will work just fine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculations Help 4
What is correct formula? 4
coloring of cel lower then end time but higher then start time 2
Countifs with different restrictions 1
Scrabble Value calculation for Welsh words 0
editing cel 2
Copied formula produces unexpected copied results 1
Counting unique values in a row 8

Top