Add times, convert to number not time of day?

S

spezticle

Okay, this should be pretty simple.

17:24:00 + 00:24:00 = 7

5:00 PM + 9:30 PM = 4.5

That's what i'm trying to achieve.
A start time, a finish time, and the time it took between them.
Not a clock time of 5pm + 9pm = 2am

How can this be done?
thanks,

Benjamin
 
S

spezticle

i forgot, i might want to add this in.

I did this:
a1 - 9:30
a2 - 10:00
a3 = a2-a1
the result is .02 ???
 
P

Peo Sjoblom

Oops! Make that

=MOD(B1-A1,1)*24


format as general or number

--


Regards,


Peo Sjoblom
 

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 Format to Text Output - A Tough One ! 4
time sheet help 3
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
date and time in 2 cells to create subtraction in 3rd 2
HELP! What's Up With Time 2
Convert times to text string 3
Suming Up Time over the course of days 1
Finding if a certain time falls between two other times: 1

Top