Excel Time Calculations

[DianeSp]

I would like to do a time calculation in Excel. I would like to enter a start time, and end time and have the formula calculate the difference returning a numeric decimal value. For example, I would enter a start time of 12:00 PM and an ending time of 1:30 PM and I want the return value to be 1.5.

 

[Andrzejek]

[pre]
A B C
12:00 PM 1:30 PM [BLUE] =(B1-A1) * 24[/BLUE]
[/pre]
Assuming columns A and B are set as TIME (not text)


---- Andy

There is a great need for a sarcasm font.

 

[DianeSp]

Perfect! That did the job. Many thanks!

 

[dhookom]

DianeSp,
Welcome to Tek-Tips . I hope you find this site valuable.

You should click the *Great Post! link in Andy's answer. It was quick, accurate, and even included TGML formatting for readability.



Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Smith_J]

Thanks @Andrzejek, I had another way of performing it but today I got one more.

--
Smith
Admin | O365CloudExperts

 

[Andrzejek]

Please share your solution so others can benefit.


---- Andy

There is a great need for a sarcasm font.

 

[SkipVought]

FYI, all date and time values are stated in units of days.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein