1.00 P is giving me 60 What is required please to add 12 hours and make it
780

I get 780. ???

However, I did run across a potential bug when dealing with 12 AM and 12 PM.

How would you enter 12:30 AM? And, am I to understand that if cell A2 does
not contain "P" then it assumed the time in A1 is AM?

Biff

"Steved" wrote in message
...


=IF(A1="",0,INT(A1+(A2="P")*12)*60+MOD(A1,1)*100)

1.00 P is giving me 60 What is required please to add 12 hours and make it
780

Thankyou


"Steved" wrote:

Brilliant and I thankyou.

"Biff" wrote:

Try this:

=IF(A1="",0,INT(A1+(A2="P")*12)*60+MOD(A1,1)*100)

Biff

"Steved" wrote in message
...
ps

ok if I have 4.50 in A1 and P in A2

P is afternoon
Is it possible for the formula to look at P in A2 and add 720 so the
answer
is 1010 please.

Thankyou

"Biff" wrote:

16.50 is the same as 4:50 pm
another example 16.50 to 1250 minutes.

OK, but 16.50 still doesn't = 1250 minutes.

16*60+50 = 1010

Biff

"Steved" wrote in message
...
Hello Chip from Steved

I ran a payroll which was designed about 40 years ago so in my
exercise
16.50 is the same as 4:50 pm. I am in the process off converting
the
payroll
to minutes.

"Chip Pearson" wrote:

The short answer is multiply by 60. But your numbers are all
wrong. Assuming that 16.50 is 16 and 1/2 hours, the correct
number of minutes is 990, not 1250. Similarly 4.50 is 270
minutes, not 530. Am I missing something?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steved" wrote in message
...
Hello from Steved

What formula will convert 4.50 to 530 minutes ( "Decimal
Time" )

another example 16.50 to 1250 minutes.

Thankyou.