ExcelBanter - Time Card

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time Card (https://www.excelbanter.com/excel-discussion-misc-queries/78108-time-card.html)

OSSIE

Time Card

HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOWS
THE EXACT TIME THE PERSON WORKED

=TIME(A1/100,MOD(A1,100),0)
gives 2:11 PM
when A1 has value 1411

--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=523774

Biff

Time Card

Hi!

Try this:

=TIME(A1/100,MOD(A1,100)-30,0)

Biff

"OSSIE" wrote in
message ...

HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOWS
THE EXACT TIME THE PERSON WORKED

=TIME(A1/100,MOD(A1,100),0)
gives 2:11 PM
when A1 has value 1411

--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile:
http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=523774

All times are GMT +1. The time now is 02:49 AM.